Hiding Records on a Report

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

Guest

I don't want certain Records from my Form to show up on my Report. Is there a
way to use a check box so that only the Records I want, show up. (I
specificly want to know about whole Records not shown not Fields)
 
I have 36 projects being worked on with information on each project on
separate records on a Form. When a project is finished or is not being
currently worked on I want to be able to click on a check box so that those
records won't appear on my report. Can it be that easy or do I have to do a
Query (which I would like to avoid)?
 
if the checkbox control on the form is bound to a field in your table, you
can filter the report's RecordSource in an OpenReport action by adding a
WHERE condition to the macro or VBA code, as

"CheckboxFieldName = False"

substitute the correct name of the field, of course.

hth
 
Back
Top