update field once upon opening, but not the 2nd time the record is opened

[vickan240sx]

Hi,



I currently have a form that has a date/time field that is automatically updated when the form is loaded.

However, when this form is closed and reopened again, the field re-updates. How can I prevent this field from re-updating. Is there some sort of VBA code that I can enter that does this when the form is loaded? Like, (if field null, then update)?

Thank you for your help!

[Bob Fitz]

Try this in the Open Event:

If IsNull(Me.[YourTxtBoxName]) then
Me.[YourTxtBoxName] = Date()
End If

[vickan240sx]

Try this in the Open Event:

If IsNull(Me.[YourTxtBoxName]) then
Me.[YourTxtBoxName] = Date()
End If

Hi,

What would be the difference of Me! vs Me.? The original code that I had in place had an "!".

 
Me!LDDDistributor = Now()

Thank you

[Bob Fitz]

I think that Now() returns the date and time. Date() just returns the date.

(!) or (.) I don't think it matters which you use here. I usually use (.) but take a look at: http://datagnostics.com/dtips/bangdot.html