Auto Populating a txt box.

[KeithB14]

Good morning,

I have two txt boxes tied to a table in a form. txtSecMgrName and txtSecMgrDate. I would like to populate txtSecMgrDate with today's date when txtSecMgrName is filled in. I have tried inserting the following code into the "On Lost Focus". =IIf([txtSecMgrDate]=Not Null,[txtSecMgrDate]=Date()). Nothing happens. Can someone point me in the right direction.

Thanks for the help,

Keith

 

[KeithG]

Use the after update event with the below code

me.txtSecMgrDate=Date()

 

[KeithB14]

That did the trick. I was making that too difficult. Thanks for the help.

Keith

 

[missinglinq]

And just for future reference, in VBA the correct syntax for

[txtSecMgrDate]=Not Null

would be

Not IsNull([txtSecMgrDate])