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]

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" <sd************@yahoo.com> wrote in message
news:43**************************@posting.google.c om...

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

[Jason Smith]

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

"Larry Linson" <bo*****@localhost.not> wrote in message news:<0D*****************@nwrddc01.gnilink.net>...

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" <sd************@yahoo.com> wrote in message
news:43**************************@posting.google.c om...

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