Using a Form to select a record to print

  • Thread starter Thread starter Greg Staley
  • Start date Start date
G

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
 
Greg Staley said:
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?
Click to expand...

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.
 
Back
Top