Guidance please

[Guest]

I need to design a "switchboard" or some kind of interim form which would
allow the user to design his/her own query to pull up records from a table.

The user could pull by date (date should be displayed) alone or in
combination with up to 4 or 5 other criteria.

Any help is appreciated. Thank you in advance.

 

[Ken Snell \(MVP\)]

Example database for multiple filters for a report/query:
http://www.cadellsoftware.org/SampleDBs.htm#FilterForm

 

[Guest]

Thank you!!

Example database for multiple filters for a report/query:
http://www.cadellsoftware.org/SampleDBs.htm#FilterForm

 

[Guest]

Hi -

I am using the code as suggested to build the query. I need to take the
records which will be pulled from this query and open a different form with
this info. At what point in the code can I enter a DoCmd OpenForm? Users need
to work on the records and pass them into a different table which I can do
but I am having trouble trying to pass the query info to the form.

Thank you.

 

[Ken Snell \(MVP\)]

Assign the SQL statement that you build via the code as the RecordSource
property of the form that you want to open.

If you build the SQL statement in the filter form, easiest way to do this is
to pass the SQL statement as the OpenArgs argument of the DoCmd.OpenForm
action (after you've built the SQL statement string), and then have the
second form (the one you open) read the OpenArgs value in the form's Open
event and assign that string to the form's RecordSource property.