Help with report coding 1

[nayfeh]

I have a report that is generated through a form. The form is named frm_PickingList. It has text boxes for StartDate and EndDate.

The main table (tbl_NOHeader) has a Printed field. It's default is set to 0 (False). I would like to update this field to -1 (True) when the report gets printed and then have a text box named DUPLICATE that is visible if this field is True.

Similar to an invoice showing duplicate if it's not the original. Thanks in advance for your help.

Thanks,
TN

 

[PWise]

in the report close
docmd.runsql "update tablename set printed=true where date between " & forms!frm_PickingList.StartDate & "and" & forms!frm_PickingList.EndDate & ";"
in detail format

me.DUPLICATE.visible = me!printed