AfterUpdate

[louchey]

Hi Guys,
Think this should be reatively simple ( though can't get it right myself)
I have a form and on the afterupdate of "ISO ISSUED AFC" it puts todays date in "Issued Date"
The problem is when I back the ticks off, obviously the"Issued Date" updates to today.
Basically what I would like is :
If "ISO ISSUED AFC" is true, update date field
If ""ISO ISSUED AFC" becomes false, Do Nothing.

I'll attach sample DB

Hope this is clear - Any suggestions would be great.

Louchey

 

[louchey]

Thankyou Pat,

As a rule I don't use spaces. Not sure what I was thinking this morning when I put this example DB together.

Many thanks once again

Ben

 

[popen_73]

AfterUpdate :

If Me. [TickBox] = True THEN
Me.[DateField] = Now()
Else
If Me.[TickBox]=false THEN
Me.[DateField]=null
End If
End If
Me.Refresh

The refresh is the key here I think.
I think that the code above is the sort of way that it should work.

Hope this helps!