the expression is typed incorrectly... error link child fields

[Sergio]

Hello,

I have the following problem I have an inventory system DB. I am
trying to combine my items form and my orders form so that the user can
browse trough the items and see which orders are associated with them.
I have a form that is based on a query and returns all the items. The
subform is also based on a query and it returns all the orders. When I
try to link the orders (Child) to the Items (Parent) using the link
child and parent field's properties I get the "the expression is
typed incorrectly...." error. If I remove it the subform works fine
but of course it will display all orders and not only the ones
associated with the current item.

Does anybody have ideas or suggestions? I am desperate please help!

 

[RuralGuy]

Hello,

I have the following problem I have an inventory system DB. I am
trying to combine my items form and my orders form so that the user can
browse trough the items and see which orders are associated with them.
I have a form that is based on a query and returns all the items. The
subform is also based on a query and it returns all the orders. When I
try to link the orders (Child) to the Items (Parent) using the link
child and parent field's properties I get the "the expression is
typed incorrectly...." error. If I remove it the subform works fine
but of course it will display all orders and not only the ones
associated with the current item.

Does anybody have ideas or suggestions? I am desperate please help!

The LinkMasterField should point to the PrimaryKey of the MainForm table and the
LinkChildField should point to a ForeignKey field of the SubForm.
_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.

 

[Sergio]

Thank you RuralGuy. The method you describe is how the main form and
subform are set up. I also tried instead of using the queries using the
actual tables and I get the same behaviour. I don't know if this is
important but there are other subfrom in addition to this one they are
all within a Tab Control.

Thanks,

Sergio

 

[RuralGuy]

Thank you RuralGuy. The method you describe is how the main form and
subform are set up. I also tried instead of using the queries using the
actual tables and I get the same behaviour. I don't know if this is
important but there are other subfrom in addition to this one they are
all within a Tab Control.

Thanks,

Sergio

A Suggestion:
Make sure the LinkMasterField and the Control it is bound to (if any) are *not*
named the same! The same with the LinkChildField.
_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.

 

[Sergio]

I found such a control and removed. Another thing I found was some VBA
code that was trying to apply a filter to my subform. I removed both
pieces and now it is working!

Thank you for you help!

 

[RuralGuy]

I found such a control and removed. Another thing I found was some VBA
code that was trying to apply a filter to my subform. I removed both
pieces and now it is working!

Thank you for you help!

<snip>

Excellent! Thanks for posting back with your success.
_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.