Update Current Record of Subform

[c.kurutz]

I have a main form holding quote information. I have a subform listing
names of people who will receive the quote. I have a button on the
subform that allows the user to email the quote to each person. I need
an afterupdate procedure that after the "email quote" button is clicked
the date and time will be entered in a text field called
CUSTOMERTIMESTAMP.

I have it working for the first record but I can't seem to get the
subform to recognize which subform record I am on and only update the
current record. The CUSTOMERTIMESTAMP

 

[c.kurutz]

CONTINUED.....
Sorry.....I hit enter before I finished typing my notes and accidently
posted before I was done.

As I was typing.....The CUSTOMERTIMESTAMP field will always update on
the first record only.

Any help would be appreciated.

 

[c.kurutz]

Figured it out.....I was referencing the field name wrong. When I
added correct syntax it worked beautifully:

Forms![frmQuoteInformation]![tblQuoteSentTo
subform].Form![CustomerTimeStamp] = Now()


Thanks...