Queries and Forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
Shep99 said:
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?
Click to expand...

Have you looked at the built in Filter-By-Form feature?
 
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
 
Back
Top