open report from form and only show records that match true criter

B

Brook

good day,

I have a form that I use to open a report, and on this form I have a check
box and the same checkbox on the report.

When I check a box(make it true) I want to be able to click my "Open
Report" button and it show only that record.

How would I do that?

Thanks,

Brook
 
S

Steve Schapel

Brook,

Is the checkbox bound to a Yes/No field in the table that the form and
also the report are based on? If so, you can simply make a query, based
on this table, put -1 in the criteria of the Yes/No field in the query,
and then use this query as the Record Source of the report.
 
B

Brook

Steve,

Thanks for the response...

Yes the checkbox is a bound to a yes/no field in the query that the form
and query are based on..

However what is happening is that when I open my form after I have added
the query criteria, I don't have any records b/c nothing has the true factor
of the shipmentrequest checkbox


Brook
 
S

Steve Schapel

Brook,

You should only base your Report on the query that has the criteria.
The form needs to based on the table, or another query.
 
Top