Automation Object Not Available error-

[froggiebeckie]

Need a second opinion on this one, if someone has the time.

The boss is asking me about this:
Small db to track keys issued to individuals.

2 tables:
#1. ID, (with auto numbering for ID,) and basic name, SS #, etc.
#2. ID and Key number, Date Issued, etc, without auto numbering.

1 to many relationship (#1 to #2).
Cascadeing Update and Delete, and referencial integrity.

He has a form and subform based on a query, wants to do basic info entry on main form (for table #1), then tab to subform to enter specific info for (for table #2).

Problem is, when he tabs to the subform, he gets "Automation Object "Keys Issued" Not Available" error message.

I've found that in his querry, he is pulling the ID from both tables.
I can stop the error by eliminating the the ID from Table #1, using only the one from Table #2.

Is this just a fluke, or do you think I may have hit on the root cause? Any suggestions for problems to watch out for?

Thanks in advance,

BeckieO

 

[RuralGuy]

Hi Beckie,

Do You have the ID field from table #1 in table #2 as a ForeignKey (FK)? If so then the MainForm should be bound to a query of Table#1 *only*, the SubForm should be bound to a query of Table#2 *only*, and the LinkChild/MasterFields of the SubFormControl should point to these two fields.

 

[froggiebeckie]

You hit the nail right on the head. Problem solved, again.

As always, you folks are the best.
Thanks
BeckieO

 

[RuralGuy]

Glad I could help.