Help:Report in Checkbox

[phatus]

hi sir,
i have a query with a yes/no check box in it.. in my criteria in yes/no i put

-1

it only shows the box with check when i generate the report...

can anyone help me how to make a button that i can open the report if i select the box with check only in my report only the box with check will show, while if i click only the uncheck box only the uncheck box will appear on my report...

the field name where my checkbox stored is "withcopy" field

thank you...

 

[Jeanette Cunningham]

Make a form where the user can select which report - you could put a checkbox. If user wants 'withcopy' they check the checkbox.

Put a button to open the report on the form.
Use the where condition of the OpenReport method to open the report. Change the Where condition depending on what the user chose for 'withcopy'.

Search vba help on OpenReport to see how to use the where condition.

 

[phatus]

o ic i have come up with this idea.. ill make 2 query 1 is all the check and 2 is the no check in the checkbox... and make 2 button to open it..

any other suggestion?