I am getting an automation error when I run my macro. Does anyone know what this means? I am attaching the picture.



I have a form called T-SubassyHDR. In this form I have a combo box that looks up Part #, Rev and description in the T-Document/Part# table. In the form I have three more fields. They are Subassy Part#, rev and description. I have the design set up that in the event tab of the combo box field "On Lost Focus" I link to the "Macro-Part Lookup" Macro. This macro is supposed to take the part # from the query and fill it into the Subassy part # of the form. Also take the rev field from the query and fill in the rev field of the form and then finally take the description field of the query and fill in the description field of the form.

This doesn't really work because I keep getting the automation error. Can anyone help and can anyone understand what I am trying to get accomplished?

Angela