Create query based on multiple selections in form.

[Areteauu]

Ok so this query is probably going to be pretty simple but I can not seem to figure it out. Background information needed: There are multiple tables that have a relationship with tblEventLog. Tables include tblCCSD, tblSatellite, tblCCI, and tblEventLog. tblsCCSD, tblCCI, and tblSatellite share a one-to-many relationship with tblEventLog. Information enters the tblEventLog via a form called frmEventLog. I need a query for tbleEventLog that will bring results from one or more fields. So a query that would search based on a date range. I also need the ability to query tblEventLog given a date range and a CCSD, CCI, or Satellite.

I really hope that makes sense and will be more than willing to give more information if needed.

[June7]

Primary options:

1. dynamic parameterized query, review http://datapigtechnologies.com/flash...earchform.html

2. construct criteria string and set form Filter property, review http://allenbrowne.com/ser-62code.html

[Areteauu]

After a little tweaking to the database I have the query working! Thank you so much!