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
Also there is no code for the combo box
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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.
ASKER
I noticed they are not using a query or table for the combo box but an "Edit List Items"
ASKER
Do not want to delete - getting responses that are helpful -
ASKER
Found solution