Table update from combo box

J

JMorrell

Having a brain freeze here. I have a form with a query as a source. I want
to be able to update a field (supervisorID) but for some reason, it's not
letting me. I get an error sound with no text.

What am I missing here?

tia,
 
A

Allen Browne

Are all controls read-only?
If so, open the query: are all fields read-only there also?
If so, simplify the query so it is not read-only.
If not, do multiple tables have SupervisorID field? Should this field be
from a different table?

If the field is not read-only in the query, check the Locked and Enabled
properties of the SupervisorID combo on the form. If they are correct, check
that is RowSource and Bound Column are correct.
 
J

JMorrell

It all checked out ok. This is a form designed by someone else so I'm
working through those problems.

Thanks for your help.
 
Top