Using a Form to select a record to print

[Greg Staley]

I know people have asked this in the past, but I cannot find and example.

I have records that are added every day. I use a query to select those from
the rest of the records by only allowing those records = Date() to be
selected.

Now I want to use a combo box to select one of those records and have that
be the only record sent to the report to be printed.

How do I achieve this?

Greg
The oft access confused

 

[Mike Painter]

I know people have asked this in the past, but I cannot find and example.

I have records that are added every day. I use a query to select those from
the rest of the records by only allowing those records = Date() to be
selected.

Now I want to use a combo box to select one of those records and have that
be the only record sent to the report to be printed.

How do I achieve this?

Add Forms!YourFormName!YourComboBoxName to the criteria for that particular
field.

You can also add a Yes/No "Printed" field to the table and select more than
one record in a subform.
A select all and Clear All button to reset the query adds to the utility of
this approach.