Combo box problems

pwicr

Registered User.
Local time
Today, 00:27
Joined
Sep 22, 2011
Messages
144
I have a combo box in a form that pulls from a table.

I added two items (see attachment - I added the bottom two to the table) and when I select either of those I get an error. (see second attachment)

This doesn't make sense to me.
 

Attachments

  • combo box.jpg
    combo box.jpg
    24.8 KB · Views: 72
  • order ID.jpg
    order ID.jpg
    17.9 KB · Views: 70
What is the Row Source for the Combo box (i.e. the value of the string)? How does that relate to the table you showed?
What is the bound column of the Combo box?
 
From your post, it would appear that you most likely have a field in the table where you added the two new values that is expecting an entry for the "Ordre TypeID" and you have not supplied a value in that field. If you provide the data in the field for the new records it should work.
 
attached is my table and my row source
 

Attachments

  • order id table.jpg
    order id table.jpg
    54.2 KB · Views: 61
  • row source.jpg
    row source.jpg
    92 KB · Views: 60

Users who are viewing this thread

Back
Top Bottom