Combo Box not letting me select options

[chris11590]

i have a combo box which will not allow me to select any of the options. i have limit to list set to no. i believe all the properties with are necessary are set correctly. any suggestions?

 

[MSAccessRookie]

i have a combo box which will not allow me to select any of the options. i have limit to list set to no. i believe all the properties with are necessary are set correctly. any suggestions?

1. What is the Control Source for the Combo Box?
2. What is the Record Source for the Form?

Each of these could contribute to your problem, although I suspect it is something about the query that is the Control Source for the Combo Box.

 

[chris11590]

the combo box is based of a sql "where" query.. its not the control or record source...

 

[boblarson]

Is the form set to AllowEdits - NO

or

is your underlying recordsource happen to be read only?

 

[chris11590]

nope.. it set to yes

 

[chris11590]

what does it mean to read only. i dont think so. one thing i did notice i did not have a parent/child relationship set on the subforms ..

 

[boblarson]

what does it mean to read only. i dont think so. one thing i did notice i did not have a parent/child relationship set on the subforms ..

As mentioned by MSAccessRookie - what is the combo box bound to? What field is listed in the combo's CONTROL SOURCE? If it is unbound then it would have nothing in the control source.

Also, if this is on a subform and the main form is set to No edits then the subform won't be editable either.