setting a date field in a form when clicking a yes/no box

[Pavkovich]

I have tried to set a date field when I put a checkmark in a yes/no field. In the date fields control source I put the following: IIf([SetDate]=0," ",Date())
Unfortunately using Date() simply changes the date each time the day changes. I want to store a date telling my when I put the checkmark in the yes/no field and I don't want that date to change. Using Date() changes it each day. How do I set the date field to todays date when I click on the yes/no field? I don't want that date to change just because the actual date changes.

Thank You!

[PEB]

Hi,

U need to do some VB!

In the properties of you checkbox find the AfterUpdate Event procedure

appears a white window in which you have to type

If me![Checkbox]=True then
Me![Mydate]=Now()
End if

So you need to change the names of
me![Checkbox]
Me![Mydate]

with yours

Close this window and run your form!

Best regards!
:)

[Pavkovich]

PEB,

I can't thank you enough, it worked like a charm! I am discovering that in order to customize Access you need to know VB, which I need to learn. I do understand the over all concept of programing but I do not understand the ME! that preceeded the field names.

Thank you very much!

Robert

[PEB]

Hi Robert,

Me remplaces Forms![YourFromName]
This indicates that the respective object - control is in the current form

In other words in my form ;)

:)

Best regards!

:)