Auto Fill textbox

[cbearden]

I have a Form with a subform.
The subform is linked to the form by strD#

The subform has these fields:
strD#
strName
strContact
strPhone
strFax
strUpdate

If someone makes a change to the record(minus strUpdate) in the subform, a textbox, strUpdate, needs to be filled with the current date (ex: 6/28/2005)

The code that I have is:
txtUpdate = Date()
I put this in the AfterUpdate for all the textboxes except strUpdate.

Could someone help.
Thanks

 

[PHV]

Why not simply this, in the BeforeUpdate event procedure of the subform:
Me![name of Update control] = Now()

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[cbearden]

The information is on Dealerships. The reason for this update box is so that the person looking at the information won't have to call to verify it everytime. If I have a date on the form, and see its 6 months old, then I might call to verify, otherwise, I'd save time by not calling.

 

[Eupher]

Hi, cbearden,

I'm not sure I understand your response to PHV. Sounds like you think his solution won't work for you. But... I think it will. Sorry if I am mis-reading your post.

Ken S.

 

[cbearden]

oops. that post was supposed to go to another forum.
sorry.

 

[cbearden]

I put that code in but it still does the same thing that the code I had...It puts the date on every record of the subform. Plus the code added the time to the date.

 

[cbearden]

I see what the problem was, thanks for the help.