Combo Box in ADP not allowing edits

A

AkAlan

I have a Combo Box that was working just fine until I converted to an ADP.
Now the data displays just fine but when I try and change the value of the
box in an existing record I get a message at the bottom of the screen saying
"Contol can't be edited; it's bound to Auotnumber field UnitID". That is the
field I want to be bounded but why won't it work? I'm reading the books to
see if there is some difference in the way ADP's handle combo boxes from
regular mdbs but haven't come up with anything yet. I even tried creating a
new combo box from scratch but get the same error. Thanks for any help
 
A

AkAlan

Found the problem, I'll post it in case this happens to anyone else. The
query my form was based on included the table that the combo box was based on
( I don't know why that was done that way) and the UnitId field that the
combo box was bound to was the Unit table's primary field instead of the
main tables forein key field of UnitId. My bad.
 
Top