Searching Forms

[who dey 85]

I am creating a database that will run off of one table. The users of the
database will have very little computer knowledge. I want the user to be able
to search records based on their number. For example, I would like them to be
able to type in the number of the record in a field and have the information
associated with that record displayed. I know you can use the navigation bar
on the bottom but would prefer an easier solution. Any advice?

Thanks for your help!

 

[John W. Vinson/MVP]

On Fri, 1 Aug 2008 17:49:00 -0700, who dey 85 <who dey

I am creating a database that will run off of one table. The users of the
database will have very little computer knowledge. I want the user to be able
to search records based on their number. For example, I would like them to be
able to type in the number of the record in a field and have the information
associated with that record displayed. I know you can use the navigation bar
on the bottom but would prefer an easier solution. Any advice?

Thanks for your help!

Yes. Use the Toolbox to create a combo box for this purpose. Make sure
the magic wand icon is selected; choose the Combo Box tool and put it
onto the form. Choose the option "Use this combo to find a record".