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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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