You have a lot of fun with me don't you?
I am really not as stupid as I appear on here (well maybe not
)
What I need is a check box for the user to declare the item complete and enter the current date into a field, now I see it can be an unbound check box as oppose to a button as pat suggests do to the continuous form's appearance. (very unattractive with a row of buttons)
But I think he is concerned with the check box getting out of sync with the date field.
My concern is using vba to set the date in the 2nd nested subform as those records are not visible on screen unless the user is on the current order detail record for the accessories record. Or will vba handle the checkbox getting checked since it is a unbound control instead of a field.
As much time as it takes me to write good code I don’t want to spend all day on it only to discover I can’t get the checkbox updated.
Sounds a little circular to me: If date is not null then chkbox true. And if chkbox =True then date = current date.
Darn it, lots too learn. where am I going wrong!