Macros or Expression????

[dsthome]

Hi I wonder if anyone can help, just upgraded to access 2007 and having difficulty with getting a date field to automatically update when I check a yes/no box, not sure if macro or expression builder is the way to go. I have had a look at a few suggestions but still having difficulties. Please post some simple instrucions if possible. Thanks foar any help...

 

[Alansidman]

Perhaps if you posted some information. Specifically what fields you want to change and under what logic or scenario. Not enough info to offer an answer.

 

[dsthome]

Hi Sorry

Didn't know what information to put.

I have a Database that has a box (yes/no data type) to tick when a certain process has been complete. I also have a date process complete field. I was trying to get the date to automatically fill the field when the tick box was checked.

hope this is enough info

 

[Alansidman]

In the afterupdate event for the checkbox control:

If me.checkboxcontrol.value = -1 Then
me.dateprocessfield.value = Date()
End If

This assumes the date process is the current date.

 

[dsthome]

Excellent Thanks Very much I knew I did something like that last time, but couldn't for the life a me remmber how I did it. Once again thanks for your help