Queries and Forms

[Guest]

I have a table set up and will set up a form to display the records.

What i want users to do is search for records by searching under different
fields e.g. user 1 may want to search on a date of birth and user 2 may want
to search on surname.

therefore, i have set up lots of queries to cope with this and then set up
the same number of forms in order to display the records on a form

this seems a long way of doing things........is there a easier way of having
1 table with lots of records and searching/updating selected records by
searching under different fields?

 

[Rick Brandt]

I have a table set up and will set up a form to display the records.

What i want users to do is search for records by searching under different
fields e.g. user 1 may want to search on a date of birth and user 2 may want
to search on surname.

therefore, i have set up lots of queries to cope with this and then set up
the same number of forms in order to display the records on a form

this seems a long way of doing things........is there a easier way of having
1 table with lots of records and searching/updating selected records by
searching under different fields?

Have you looked at the built in Filter-By-Form feature?

 

[Allen Browne]

There's a very simple (to implement) solution here:
Find as you type - Filter forms with each keystroke
at:
http://allenbrowne.com/AppFindAsUType.html
It allows the user to choose a field (from a combo) and type a value to
match. With each keystroke they type, the form filters to show only the
records that contain that value.

If you want to give them the flexibility to enter criteria for lots of
fields at once, it takes a bit more work, but you can download this sample
database:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html