Link to home
Start Free TrialLog in
Avatar of leezac
leezac

asked on

MSAccess 2010 Combo Box not letting me select

I have a combo box on a form where I need to select values from a table to insert into another table, but it is like the combo box is disabled and will not allow me to select from the drop down.  Any one have suggestions?  I have compacted the database and chose Unique on the query properties for the combo box.  So far nothing works.

Also there is no code for the combo box
ASKER CERTIFIED SOLUTION
Avatar of Anastasia D. Gavanas
Anastasia D. Gavanas
Flag of Greece image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of leezac
leezac

ASKER

I've requested that this question be deleted for the following reason:

Found solution
also check
1) Does the control source for the combo box need to be a foreign key to the row source it is referencing?
2) Check the properties of the combo box and make sure locked is set to No.
If it is set to Yes it will cause the problem you have stated.
Avatar of leezac

ASKER

I noticed they are not using a query or table for the combo box but an "Edit List Items"
Avatar of leezac

ASKER

Do not want to delete - getting responses that are helpful -