Filtering records, with SQL using multiple records

[jamiedora]

Hello,

I'm trying to populate a contiuous form based on a filter; however I
would like the filter to be based on the filtering of muliplie fields
(i.e. return records based on Field1 = Value1 and Field2 = Value2).

How would one perform this via SQL command and visual basic. Does
anyone have an example.

Thanks,

Jamie

 

[Allen Browne]

See:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html

Includes a sample database you can download and pull apart to see how it
works.

 

[jamiedora]

Thank you so much; this is a great example!

See:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html

Includes a sample database you can download and pull apart to see how it
works.