LookUp Field

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

Guest

I have a Form based on a Query. I have fields that are combo boxes and need
to select from these for entry on the Form. I can see the list but cannot
choose from the list. I have done this with the Lookup Field in the table
and it worked great. I have been told I shouldn't use Lookup Fields in a
Table so I am trying this. My Control Source and Row Source have the correct
fields because I can see the data. How can I correct this so we can choose
from the list?
Thanks!
 
Hi, Sam.

Check that the Locked property of the combo box is not set to Yes, but I
suspect it's more likely that the query is non-updateable. Try opening the
query itself to see if you can add data directly.

Sprinks
 
No, I can't enter date into the Query. Why is it locked and how do I unlock
it? Also, How do I UNreplicte a form? I simply went to Properties and
Unchecked Repicate on the Tables and Queries but do not have that option on
the Form.
Thanks!
 
Hi, Sam.

If you cannot edit your query directly, it is "non-updateable". There can
be many reasons for this. One big one is including the primary key from the
one side with records on the many side. If you were able to change the key
on the One side, you'd be left with Orphan records on the many side.

Beyond that, Access Help gives some direction on identifying and correcting
this situation. The topic has also been covered here--search on
"non-updateable".

Hope that helps.
Sprinks
 
Back
Top