Store Value in Subform

[milcman]

I am using a custom, auto-incrementing value as a record ID,(read - not PK), on a form(frmNewWPAO). I tried using similar code but diferent reference values to do the same for a subform(frmServiceTicket) 2 levels down from the main form. (Form levels: Main=frmWPAO, sub1=frmWPAO_Order, sub2[of sub1]=frmServiceTicket).

When I open frmServiceTicket directly, the correct value is in the txtServiceTicket field, when I open the main form, no value is in the subform frmServiceTicket!txtServiceTicket field.

Any suggestions?

Clint Galliano
Halliburton Energy Services
BAROID PSL
"Done ONCE, Done RIGHT!"

 

[milcman]

I figured it out. Instead of having it on the "On Load" event, I triggered it from the "On Dirty" event of the first field. Works fine now.

Clint Galliano
Halliburton Energy Services
BAROID PSL
"Done ONCE, Done RIGHT!"