Subform Problem Error - This expression is typed incorrectly

[Nate via AccessMonster.com]

Hey all

I am having a problem with a subform.
I am creating a purchase order form based on my purchase order table. I
added a subform so that a user can enter many part numbers, descriptions,
prices ect. This is based on a separate table. Everytime I open the
purchase order form I get the following error: "This expression is typed
incorrectly, or is it too complex to be evaluated."
I have a feeling that there is a problem with the relationship between the
two tables, but I'm not sure. It is currently a one-to-many. (One order to
many parts).
I have tired creating the subform over and over using the wizard. When I
first create the subform it will let me add parts, but when I close it and
open the main form I get the error.
I have spent hours looking through the postings, but I can't find anything
specific.
Any help is appreciated.

Please be specific with instructions.

Thanks
Nate

 

[Wayne Morgan]

First, it appears that your "subform" is a separate form, not a subform on
the main form, is this correct? When you are "adding parts", is this a table
that holds all available parts that can be selected when an order is created
or is this a table that holds the parts that have been selected for the
orders?

Right off-hand, it sounds as if you need your "subform" as a true subform.
Place it on the main form. When you do this, you will have the option to
link Child and Master fields. These should be the same fields that the
relationship is on between the two tables. Now, when you select a purchase
order, the subform will show the parts ordered for that purchase order.