select in a form/report

FANQ(frequently asked new questions)

select in a form

Make a variabel strSQL in your Form
fill de SQL string directly or make it out of
a couple of dropdown fields which fill the
string of the SQL
Try it out with making a query with your database
assign a event After_Update to the strSQL with
Me.RecordSource=Me!strSQL

to select for a labelreport:

in the report assign a event On Open to the report with
Me.RecordSource=Forms!Formnaam.RecordSource
(Is for both MS Access 2.0 and MS Access 95)