wo****@comcast.net (Won Mee) wrote in
news:4e**************************@posting.google.c om:
How do you run macros on subforms when a mainform opens up.
I've tried to link it but it says object doesn't not exists.
It somehow can't find the subform.
Thanks
That's because the subform is a control on the mainform, and does
not exist in the forms collection.
You must refer to your subform object by referencing through the
form object,
the generic expression is Forms!Mainform!ctlsubform.form
ctlsubform is the name of the control whose source object is the
subform you are trying to manipulate, and is not necessarily the
same as the subform's name in the database window.
--
Bob Quintal
PA is y I've altered my email address.