Subform Troubles

[Guest]

Morning
I have 2 subforms (both bound on 2 different queries, one Structures and one
Inspections) in an unbound form and nothing is linked.

If I put any code in either subform I get a communication error with OLE or
ActiveX control.
(Even if the code is Msgbox "Hi")

I have never had a problem with this before and I checked the KB on this
problem and nothing there helped.

Any Suggestions?

Thanks
Joel

 

[Guest]

I would try three things
1. Compact and Repair
2. Check the reference, if any thing is missing (Open code, from the menu
bar select tools > reference, check if any thing is missing)
3. If the two above are OK, I would create a new form and check it.
Sometimes it is better to create a new form, rather then trying to find the
error in the existing form that might be corrupted

 

[Guest]

I remade both Forms and it worked like it was supossed too, very odd.
Thanks again for your help Ofer.