Ahhg! These combo boxes!

[itchy]

Hi! Here's the deal. I have a form whose purpose is to search one of two tables for specific information in specific fields and then display this information in a subform. The form has two check boxes (one for each table), a combo box, and a text box. What I have tried to do is when one of the check boxes is selected (has a 'true' value) this will trigger a macro which is supposed to set the combo box's RowSource property to the corresponding table (this is done using the setvalue method and note that the RowSourceType for the combo box is set to 'Field List' in order to view the tables' field names). However, when I try it, I get the following error message:
The object doesn't contain the Automation object 'tblClients'.
You tried to run a Visual Basic procedure to set a property or method for an object. However, the component doesn't make the property or method available for Automation operations.
(note - 'tblclients' is the table that was selected therefore the table whose fields I am trying to use in the list for the combo box)
Is there a way around this? I cannot think of another way to do this! Comments please!

 

[TGHockett]

itchy ...

I don't have an answser for you, but as an experienced-recipient of the same 'Automation' mssg

I CAN tell you that 9 out of ten times there is a workaround solution, since that mssg relates to Acc2K (and possibly Acc97), thinks you are trying to send to or receive data to/from one of the other Office products via the 'Automation' procedures which I do not understand... but I can assure you it is not a problem directly tied to comboboxes per se....

If no one responds with a better answer for you to this note, I suggest you re-submit your question in the General topic here under something like "'Automation' Error Problems" or somesuch.

Good luck ... TGH