Combo Box in ADP not allowing edits

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Back
Top