is there an on record change property?

[Maggie24]

Hi all,
I have a simple form which was created based on a table.

On my form I have an updated yes/no field which is filled when the record is updated.

I want make a no of fields invisible if the record has not been updated.

I need to check if the record has been updated each time i change a record so I am wondering is there an on record change property?

This is the code I am using:

If Updated.Value <> 0 Then
Updated.Visible = True
[Materal Type].Visible = True
[Base UOM].Visible = True

Else
Updated.Visible = False
[Materal Type].Visible = False
[Base UOM].Visible = False


Or do I need to open a link to my coressponding updated column in my DB and check its value instead of checking the textfield value??

Please help!

Maggie


"Work is the curse of the drinking classes

 

[hymn]

Try doing it on the "On Current" event

Hope this helps
Hymn

 

[MichaelRed]

in BOUND forms, the dirty property denotes that a value has changed. See the ubiquitous {F1} (aka help) for more basic info.




MichaelRed
mlred@verizon.net