Set value

  • Thread starter Thread starter Ivor Williams
  • Start date Start date
I

Ivor Williams

I have a form with a subform. On the subform is a check box chkOrder and a
text box txtDate. On the form is a print button which, when clicked, prints
a report containing all the records in which chkOrder is checked. When the
report is finished printing or is closed, or before the form is closed, I
would like to set the value of txtDate on the subform to todays date
wherever chkOrder has a value of -1. Please let me know how to acheive
this.

Ivor
 
Ivor,

In the Form_Unload Event I would add the following code.

If Me.chkOrder = -1 then
Me.txtDate=Date
Else
End If
 
Looks like the right approach, but when I try to close the form, I get a
message that says "Can't assign a a value to the object" and the line
Me.txtDate=Date is hilighted. Any ideas?
 
Back
Top