Test for change in a subform

B

Bonnie

Hi Folks,

I have a subform on a form - how can I test for data change in the subform
to trigger an event on the form? I tried running a macro from the
OnDataChange event but it doesn't seem to realize that the data has been
changed in the subform. Actually, I have tried all kinds of On events.

You help is appreciated.

Thanks
 
M

[MVP] S.Clark

The subform is its own form, with its own events. Thus to trap for
something in the subform, you would need to put the code in the subforms
module, not the main form's.
 
S

Sharkbyte

Bonnie:

How are the changes made? User updating fields on the subform? Are you
trying events on the subform itself, or on the subform object within the
primary form?

Sharkbyte
 
B

Bonnie

I want to update a field on the main form (put in the date we are receiving
materials) but only after I am sure they have updated the subform (so I don't
update the main form when someone just opened the form but didn't log in
anything. So I was trying to use and event like OnChange or DataChange to
fire a macro to change the field on the master form.
 
Top