I'm a novice user hoping for some quick help.
I have created a master form with two subforms.
The master form (ProjDataForm) contains an autonumber ID field (ID). It houses the primary key.
The subforms (FeatDataForm and FutuireFeatDataForm) are linked to the primary key via dummy (non-visible) number fields. Each subform also contains an autonumber field that numbers each subrecord as it is entered.
The forms seem to work well together, with both subforms capturing as many records as needed and tying them to their appropriate master record. I would like to have the subforms restart numbering at 1 each time a new master record is opened. I've done some research and tried applying different expressions using the DMax function, but I'm not sure what event to apply it to or how to differentiate between forms.
Again, all help is appreciated. Thanks in advance.
I have created a master form with two subforms.
The master form (ProjDataForm) contains an autonumber ID field (ID). It houses the primary key.
The subforms (FeatDataForm and FutuireFeatDataForm) are linked to the primary key via dummy (non-visible) number fields. Each subform also contains an autonumber field that numbers each subrecord as it is entered.
The forms seem to work well together, with both subforms capturing as many records as needed and tying them to their appropriate master record. I would like to have the subforms restart numbering at 1 each time a new master record is opened. I've done some research and tried applying different expressions using the DMax function, but I'm not sure what event to apply it to or how to differentiate between forms.
Again, all help is appreciated. Thanks in advance.