Creating Multiple Time Stamps

[pjstrat00]

Hello,

I'm trying to have a field update with a timestamp once a form has been submitted. The fields on the table are-



ManagerApproval - this contains a dropdown box with 3 options. 1. Approved 2. Denied 3. Pending - This is a text box
ManagerReviewed - this is the timestamp field that I want to populate with a date/time stamp once the form containing the dropdown boxes approved, denied, pending are submitted.

I have tried creating an after update event with the following code-However, the field "ManagerReviewed" is not appearing in VBA, thus no timestamp is being created.

Me.ManagerReviewed = Now()

However, the field ManagerApproval does appear and it replaces the text 1.Approved 2. Denied. 3. Pending with a timestamp

Help is much appreciated! I've been using access for about a month...yikes

-PJ

[June7]

These two fields actually exist in the table? They are both included in the form RecordSource?

If you want to provide db for analysis, follow instructions at bottom of my post.

[pjstrat00]

They do both exist in the table. One to state whether the request was approved/denied and one to record when the approval/denial occurred.

The RecordSource only has the table name listed.

[June7]

That is odd.

The ManagerApproval combobox works?

If you want to provide db for analysis, follow instructions at bottom of my post.

[pjstrat00]

Yep, the ManagerApproval combo box works and it will update the current record when approved or denied. (working on removing confidential data for db analysis)