Forms and Subforms

[Tina]

I have a form that has 2 subforms. The main form is the
customer, the first subform is systems for each customer,
and the second subform has information for each system.
They are linked by both Customer ID and System ID. When I
go to add a new record and all the information for each
subform, the second subform will not update and has the
following error "automation object". Component doesn't
make the property or method available for automation
operations. What am I doing wrong???????

Thanks for any advice that can be given!!!

 

[Evi]

My suspicion is that you have some code in either the main form or in one of
the subforms which was written for an earlier version of access.

First open any module (if you don't have one, just open a New one) and look
in Tools, References to see if any of the references have MISSING next to
them. If you have either write back or look up Missing References in Google
to see what to do.


If there is nothing missing there then open each form and subform in Design
View and look for any code. If you find any, put an apostrophe in front of
any lines that start with On Error. When your error messages next opens you
may now have a Debug button. That will highlight the bit of code that is
causing the problem. Write back if this happens, with the details of the
code line.

 

[Tina]

I checked the code and there was no Missing references. I
then checked the rest of the code and received no error
messages when I debugged it. Do you have any other
ideas?????

 

[Evi]

I'm stumped. Automation Obect errors seem to have something to do with code
that uses other programs eg Excel. Is that what your database does?

You will need to post the code here and hope that one of the experts can
spot the problem.
Evi