Drop Down menu help

[Johnhook]

Hi

I have a problem involving a combo box on my input form in my database.

The database has two tbls one which is tblitem and the other which is tblcustomer.

The problem lies in the new item entery form (frmitem). I have a combo box which selects the customer ID from a list, this drop down menu also contains the customer name so the user can see which customer ID is which though customer name is not part of tbl item. It looks like "Bob | 34" in the box.

The problem is that when i submit a new record through the form it does not save it into the table. When i remove the combo box and manualy input the ID it works fine but this is not adecuate for my form as it would make the database impossible to use.

Thanks for all you help in advance

Jon Hook

 

[Fizzio]

It is likely that you are trying to save the text value 'Bob' to a number field. If you are storing the CustomerID as foreign key, it is more likely that you will need to store the numeric value and therefore the bound column of the combo needs to be set to 2.