I am using an access 2003 frontend with a sql server backend.
I have a subform that is set to have a Continuous Forms view. Each detail record has a dropdown box and a text box where the user can select the appropriate item(dropdown) and enter in the corresponding weight (text box).
The trouble is with the dropdown box. The control source is the Item field on TableA. The row source for the drop down is the item description with the item id appended to it(column 1) and the item id(2nd column). The 2nd column is bound to the item field on TableA.
When I pull up the form and click on the dropdown arrow, I get an ODBC Error:
"ODBC -call faied.
...Cannot insert the value NULL into column "Item" ...column does not allow nulls. Insert fails. (#515)..."
Is the db already trying to save back the record before I input in any data?
If so, how can I prevent this?
Sounds like you have your combo box bound to the wrong field (Item) or it's bound column is not set correctly. When you select an item from a combo box, only the key is sent to the underlying field, not NULLS.