Updating field based on Value of another field

Can somebody help me with this scenario?
I want to update a date field when another field has a certain value
entered.

It is something like this:

When the PDetType field ( from tlkpERegStatus and tblPmtDetail) has a
value of "DO" ("Donation") or "SC" ("Scholarship Contribution")
entered, update the field NWCInvolveDate in the tblNWContact with the
current date.

Thanks in advance.

You could do this in a form and use the PDetType control's AfterUpdate event.
Otherwise, you can do this at the table level with a query that scans
PDetType and updates the other fields. The key is linking the tables
together properly. If you do this in an update query, use the criteria
IsNull([NWCInvolveDate]) so that old data is not overwritten. If you do this
in a form with the AfterUpdate event, try something like:

If Me.PDetType = "DO" Or Me..PDetType = "SC" Then
Me.NWCInvolveDate = Date
End If


abprules wrote:--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200612/1