Help with expression / validation in Access

[redeyes1965]

Hi can anyone help with this.

I have a field that is a true/false (check box) field called diposed. I also have a field called disposed date. I want disposed date field to insert the date if the disposed field is true.

Can i do this in the design of the dipsosed date field?

If not how?

Thanks

 

[hymn]

if diposed = -1 then
[disposed date] = now()
end if
I would place it in the after update of the of control disposed

Hope this helps
Hymn

 

[redeyes1965]

Thanks for this, i cant actually make it work though. I am sure that this is just me.

am i right in thinking that i should putting the validation on the disposed control on my form.

This is what i am doing, also i get three options
a)expression builder
b)code builder
c)macro builder

which one should i be using

Thnx

 

[hymn]

On the Control/Field "diposed" Properties, After Update, Code Builder

Hope this helps
Hymn