"object doesn't contain the automation object"

[Aries via AccessMonster.com]

Hi everyone,

I have a form with subform having 3 cascading combobox named cboManufacturer,
cboCategory, (both unbound) and cboProduct (bound). The form is for entering
delivery transactions so I have these tables

tblDeliveries
DeliveryID - pk
DeliveryDate

tblDeliveryDetails
DeliveryDetailsID - pk
DeliveryID - fk to tblDeliveries
ProductID
Quantity
UnitPrice

the cascading combos works fine but whenever I select a value on the third
combo "cboProduct" access prompts me with the message "the LinkMasterFields
property setting has produced this error: 'The object doesn't contain the
Automation object 'tblDeliveries."

I can simply click the OK button and the message disappears and can continue
with the record as if nothing happened. what could be causing this message to
appear and how to resolve this?

Thanks!

-Aries.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200904/1

[Mike Painter]

Aries via AccessMonster.com wrote:
> Hi everyone,
>
> I have a form with subform having 3 cascading combobox named
> cboManufacturer, cboCategory, (both unbound) and cboProduct (bound).
> The form is for entering delivery transactions so I have these tables
>
> tblDeliveries
> DeliveryID - pk
> DeliveryDate
>
> tblDeliveryDetails
> DeliveryDetailsID - pk
> DeliveryID - fk to tblDeliveries
> ProductID
> Quantity
> UnitPrice
>
> the cascading combos works fine but whenever I select a value on the
> third combo "cboProduct" access prompts me with the message "the
> LinkMasterFields property setting has produced this error: 'The
> object doesn't contain the Automation object 'tblDeliveries."
>
> I can simply click the OK button and the message disappears and can
> continue with the record as if nothing happened. what could be
> causing this message to appear and how to resolve this?
>
> Thanks!

Try compiling the app. Sometimes Access throws error messages that have
nothing to do with the real problem.

[Aries via AccessMonster.com]

What do you mean by "compile"? how do I do it?

Mike Painter wrote:
>> Hi everyone,
>>
>[quoted text clipped - 23 lines]

>>
>> Thanks!
>
>Try compiling the app. Sometimes Access throws error messages that have
>nothing to do with the real problem.

--
Message posted via http://www.accessmonster.com

[Aries via AccessMonster.com]

issue fixed by modifying link master and child fields property.

thanks access monster.

[Mike Painter]

Aries via AccessMonster.com wrote:
> What do you mean by "compile"? how do I do it?
>

Open a code module, select debug, then compile.