Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

ComboBox won't allow me to select an item

Tags:

ms-access

This should be a quick one for you access vets, but from trying different properties and googling about, I can't fix it:

A combobox on my form won't allow me to select an item/value. I click on it, it's correctly populated, but I cannot select any of the items. The control source of this comboBox is set to a field in a table from a query(on which the form is based). The row source for this comboBox is set to a table which defines the allowed selections(say '1','2','3','4',or '5'). So, I want to constrain the data to only those items specified in the row source for the combobox - that was my solution.

The form is set to allow edits, additions, etc. The combobox control is not set to 'locked.'

Do any explanations / solutions come to mind?

EDIT: This also applies if the control is a text box - it must be something wrong with the control source?

like image 728
Scotch Avatar asked Jul 12 '12 16:07

Scotch


People also ask

Why does my combo box say unbound?

An unbound combo box is just that - it's not bound to any stored value in any table. So selecting a name from the combo box does absolutely nothing! What is the Recordsource for your Grievances form?

How do I edit a ComboBox in access?

Access automatically creates a combo box bound to the field. Tip: To change a combo box to a list box (or vice versa), right-click the control, click Change To on the shortcut menu, and then click the control type you want.


1 Answers

There was a method called in the Form_Load() event that iterated through the control's forms and locked them by default unless a particular criteria was met. This can be a lesson to those developing databases that will be inherited in the future to comment your code to save the new guys a lot of headache!

like image 54
Scotch Avatar answered Oct 05 '22 05:10

Scotch