By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,224 Members | 1,143 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,224 IT Pros & Developers. It's quick & easy.

Using forms and queries.

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Nov 12 '05 #2

P: n/a
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

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.