if not to sure how to use the after update macro but what I want is when a field in the "Status" column changes to "ACTIVE" then the field in column "Trans_Date" changes to todays date.. thank you
if not to sure how to use the after update macro but what I want is when a field in the "Status" column changes to "ACTIVE" then the field in column "Trans_Date" changes to todays date.. thank you
Use AfterUpdate event of Status control - is this a combobox?
If Me.Status = "Active" Then Me.Trans_Date = Date()
What should happen if Status is changed to something else?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
yes its a dropdown within the table
Can't have this code behind a table, must be behind a form.
I never build lookups in table.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.