How do you create a form in access to search for records

[RyanSa]

I would like to know how to create a form to search for various records that are held in a table .

 

[GingerR]

there are a million ways.
for example, you could merely put the table in a form in datasheet view, and users can sort and filter by right-clicking and making their selection from the shortcut menu.
or you can put on combo boxes from which users select specific information and the form goes to the record that matches that item. or a subform displays records which match the selected item. or you can use radio buttons....etc etc......

please be more specific.

 

[RyanSa]

Thanks for your reply. What I need to do is search a list of codes, I would like to have a form that has a form that allows a user to type in a code in a box press a 'search' button and then the corresponding record is found and the associated data is displayed. What would be the simplist wat to do that, it sound like your suggestion of combo boxes and user specific information matched best.

 

[GingerR]

so make your form, based on your table. display all the field on the form like how you want it.
then put on a combo box: this may be based on a field in the table that the form is based on, or it may be data from another table. in any case, use the wizard and choose the third option "find a record based on my selection". it will walk you thru it. when you are done, you should be able to choose something in your combo box, and the form will move to the record that matches it.

 

[RyanSa]

Worked like a dream! Its great when you know what you are doing. Thanks again.