add check box to form

[Anthony]

Hi
I have a client that has access97 with an existing data
base..he wants me to add a check box on the form, then
insert a condition in a couple of reports that would
basically do "if box checked print, skip record and goto
next"

Any help would be great!
Thanks
Anthony

 

[tom]

Place a new field in the underlying table, with a Data Type Yes/No. Using
the Field List, place the new field on your form. Then, in the RecordSource
of your reports, add the new field to the grid (uncheck the Show checkbox)
and place a criteria of 0 (zero) into it (0 = False and -1 = True) i.e. if
the checkbox is not checked (0) then include it on the report.

HTH.

Tom.

 

[Anthony]

Thanks Tom I will give it a try
Anthony

-----Original Message-----
Place a new field in the underlying table, with a Data Type Yes/No. Using
the Field List, place the new field on your form. Then, in the RecordSource
of your reports, add the new field to the grid (uncheck the Show checkbox)
and place a criteria of 0 (zero) into it (0 = False and - 1 = True) i.e. if
the checkbox is not checked (0) then include it on the report.
.