if and then

[tubar]

i want to create an event procedure when a box is clicked but have had no luck...something like

if [relamped] is true then [date relamped]=date()

can someone give me a code for this

 

[SOS]

In the After Update event of the checkbox (I assume the checkbox itself is named relamped, but if not then change this code to what it should be) put this:

If Me.relamped Then
   Me.[Date Relamped] = Date
End If

What should happen if they uncheck the box? Does it change the date, remove the date, or what?

 

[tubar]

what would i add if i wanted the date removed if unchecked?

 

[SOS]

If Me.relamped Then
Me.[Date Relamped] = Date
Else
Me.[Date Relamped] = Null
End If