Please Help - Setting Value of Field When Data Changes

  • Thread starter Thread starter Anonymous
  • Start date Start date
A

Anonymous

Please help. This should be simple but I'm having a lot of issues. Very
simple form with single table driving it. I have a text box called
"TrackingNum" that is tied to a field in the table which is also called
"TrackingNum". I have another text box on the form called "DateEntered".
It is tied to a field in the table called "DateEntered".

I'd like the value in DateEntered to automatically be populated with the
current date whenever the user adds something or edits information in the
TrackingNum box. I set the "AfterUpdate" property of TrackingNum to do the
following:

DateEntered=Date

However, I keep getting errors. Can you please help?

Many thanks!
 
Please help. This should be simple but I'm having a lot of issues. Very
simple form with single table driving it. I have a text box called
"TrackingNum" that is tied to a field in the table which is also called
"TrackingNum". I have another text box on the form called "DateEntered".
It is tied to a field in the table called "DateEntered".

I'd like the value in DateEntered to automatically be populated with the
current date whenever the user adds something or edits information in the
TrackingNum box. I set the "AfterUpdate" property of TrackingNum to do the
following:

DateEntered=Date
Click to expand...

That's not the way to do it. The value in the AfterUpdate property
needs to be either the name of a Macro, [Event Procedure] to call VBA
code, or a call to a function =MyFunc().

Instead, set the textbox's DefaultValue property to Date().

John W. Vinson[MVP]
 
Back
Top