I am trying to create a combo box in a form that gets its data from one table and saves it in another.
I have my main table called serial list. When you use the Work Order form all data entered goes into the serial list table. The fields ranges from the customer to the part number to the serial number to the Purchase Order #, etc, etc.
I have a secondary table called Part number association. In the Part # field this table contains a list of every part number we work on. In the Desc field there is a short decreption of the part. In the MFG field it lists what MFG makes the part and in the final field it lists what department each part number goes to.
I open the work order form in design view and click the combo box button which brings up the combo box wizard. Now I choose the "I want the combo box to look up values in a table of query and then click next. Now I choose the Part number association table and click next. For this particullar combo box I want the field to be the part number, so I choose Part # and click next. The hide key column is checked and the width is good so I click next. Now I get the choice of Remembering the value of Storing the Value. Well I want to store the value in this field in the Serial List field "Part #" so I chose that and Click next. Name the field Part # and click finish.
Now I try to use this form and I a get an error "The value you entered isn't valid for this field. For example, you may have entered text in a numeric field of a number that is larger than the FieldSize setting permits. I have checked these settings and the are both set to text at 255.
Can any one tell me why this is happening?
I have my main table called serial list. When you use the Work Order form all data entered goes into the serial list table. The fields ranges from the customer to the part number to the serial number to the Purchase Order #, etc, etc.
I have a secondary table called Part number association. In the Part # field this table contains a list of every part number we work on. In the Desc field there is a short decreption of the part. In the MFG field it lists what MFG makes the part and in the final field it lists what department each part number goes to.
I open the work order form in design view and click the combo box button which brings up the combo box wizard. Now I choose the "I want the combo box to look up values in a table of query and then click next. Now I choose the Part number association table and click next. For this particullar combo box I want the field to be the part number, so I choose Part # and click next. The hide key column is checked and the width is good so I click next. Now I get the choice of Remembering the value of Storing the Value. Well I want to store the value in this field in the Serial List field "Part #" so I chose that and Click next. Name the field Part # and click finish.
Now I try to use this form and I a get an error "The value you entered isn't valid for this field. For example, you may have entered text in a numeric field of a number that is larger than the FieldSize setting permits. I have checked these settings and the are both set to text at 255.
Can any one tell me why this is happening?
