Error Message Regarding "Automation Object"

[Endre]

I have had similar problems in the long distant past where you have controls on your form the same name as your query field outputs. Sometimes when they are the same, the code referencing can get it's knickers in a twist and doesn't know whether you are referring to the control, or the control source i.e the query output. In your case you have used the name "autonumber" in many places, both as query outputs (twice) as well as control names and bound source data. By implicitly naming the [Main Table].[Autonumber] in the query output as MTAU, when we refer to MTAU there can be no doubt as to what it means. So we can use MTAU as the Child Reference.

 

[LadyDi]

That solved the problem. Thank you all very much for your assistance.