Choosing records

  • Thread starter Thread starter H. Martins
  • Start date Start date
H

H. Martins

Hi.

I need to make a Where statement to apply to a query.

I need to list several small tables and allow the user to select the
ones (one side) that should be displayed (many side) in a query.

It looks reasonable to me that I could create a 'tag' field in each of
these tables linked to a form toggle button so that the tag field
could be modified according to selection and could later be used as
source of some Where building routine.

Is this a interesting way of doing things?

Thanks
Henry
 
In Access, you create a form as the interface to your data.

If you want to provide a form where the user can enter criteria against
several fields, this example might help:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html

If you just want the user to be able to search one field at a time, this one
does not require you to write code (i.e. it's copy'n'paste):
Find as you type - Filter forms with each keystroke
at:
http://allenbrowne.com/AppFindAsUType.html
 
Back
Top