Multi-choice option from a form

[Martin hopkins]

Hi,

Could anyone help please?

I wish to load a form for a all users for them to select a report to run by
selecting a raido button/ tick box etc. The report is always the same but
with a different fiels outputr eg number of personnel at work today for
either an Electrician or Fitter etc.

So the user open form At Work Today the select either option Electrician or
Fitter and is prresent with a report on the personnel at work using his
selection.

I need to run this for several reports. Currently I have set the query to
dispaly a dialogue box saying enter trade, but if you do not know the exact
trade desriptions etc then you get no report. If i could present radio
button or a drop down box then that would be great.

Thanks in advance fro the help.

Martin Hopkins

 

[Guest]

The source of the report should include all the trade people, without a filter.
You should assign the filter with open report command

docmd.OpenReport "ReportName",,,WhereCondition
eg
' If the field is number , or if you using a TRUE/FALSE field
docmd.OpenReport "ReportName",,,"[Trade field name in table] = " & me.[Field
Name in form]
' If the field is string
docmd.OpenReport "ReportName",,,"[Trade field name in table] = '" &
me.[Field Name in form] & "'"