Using forms and queries.

[Mike]

Hi. This is my first time posting on your site, so I hope this
question hasn't been asked 50 times already. I know this is probably
a really easy question, but I have a real simple form set up. I have
4 text fields and 1 list box. What I want is to be able to enter the
data (user id) in one of the text box's and have it have it query the
table looking for that user id. If it finds it I want it to
automatically put in the data I have previously saved in the table for
the list box and one of the other text boxes. Can I use a query to do
this or do I need to create a macro? Does anyone have any documetation
they could send me on how to do this. If you would like to see the
file, I have no problem sending it to you just let me know your email
address.

Thanks in advance,

Michael

[Larry Linson]

Re: Using forms and queries.

Instead of using a Text Box, use a Combo Box, make sure the Control Wizard
is "on" (the "magic wand" symbol in your toolbox appears depressed) and
carefully read the options -- one of them does exactly what you want. And,
it also "checks" the value entered. Using a text box, there's no assurance
that what the user enters will actually be a valid value that is in the
table.

Larry Linson
Microsoft Access MVP

"Mike" <sdsnakeshooter @yahoo.com> wrote in message
news:434d2af0.0 405191428.4514a 39d@posting.goo gle.com...[color=blue]
> Hi. This is my first time posting on your site, so I hope this
> question hasn't been asked 50 times already. I know this is probably
> a really easy question, but I have a real simple form set up. I have
> 4 text fields and 1 list box. What I want is to be able to enter the
> data (user id) in one of the text box's and have it have it query the
> table looking for that user id. If it finds it I want it to
> automatically put in the data I have previously saved in the table for
> the list box and one of the other text boxes. Can I use a query to do
> this or do I need to create a macro? Does anyone have any documetation
> they could send me on how to do this. If you would like to see the
> file, I have no problem sending it to you just let me know your email
> address.
>
> Thanks in advance,
>
> Michael[/color]

[Jason Smith]

Re: Using forms and queries.

Sure, and maybe we check your table structure for normilization while we're at it.





"Larry Linson" <bouncer@localh ost.not> wrote in message news:<0DVqc.400 3$dq4.2722@nwrd dc01.gnilink.ne t>...[color=blue]
> Instead of using a Text Box, use a Combo Box, make sure the Control Wizard
> is "on" (the "magic wand" symbol in your toolbox appears depressed) and
> carefully read the options -- one of them does exactly what you want. And,
> it also "checks" the value entered. Using a text box, there's no assurance
> that what the user enters will actually be a valid value that is in the
> table.
>
> Larry Linson
> Microsoft Access MVP
>
> "Mike" <sdsnakeshooter @yahoo.com> wrote in message
> news:434d2af0.0 405191428.4514a 39d@posting.goo gle.com...[color=green]
> > Hi. This is my first time posting on your site, so I hope this
> > question hasn't been asked 50 times already. I know this is probably
> > a really easy question, but I have a real simple form set up. I have
> > 4 text fields and 1 list box. What I want is to be able to enter the
> > data (user id) in one of the text box's and have it have it query the
> > table looking for that user id. If it finds it I want it to
> > automatically put in the data I have previously saved in the table for
> > the list box and one of the other text boxes. Can I use a query to do
> > this or do I need to create a macro? Does anyone have any documetation
> > they could send me on how to do this. If you would like to see the
> > file, I have no problem sending it to you just let me know your email
> > address.
> >
> > Thanks in advance,
> >
> > Michael[/color][/color]