Using Form to Select Records in Query to Display in Report

J

JHK

I have a table named TimesJB5, which contains a field named Unit#, which is a
text-type field.

I would like to present the user with a Form which lists 10 different check
boxes each with a unit#. Depending on which boxes the user checks, I would
pass this information to a query, which would select the corresponding unit#
records and then display the records in a report.

I plan to use a CommandButton on the form that would run the proper macro to
open the query and then the report.

What would the proper syntax be to have in the query to select the proper
unit# records from the table?
 
Top