CODEWITHSUNDEEP
ms-access
Scotch
Scotch

Reputation: 3226

ComboBox won't allow me to select an item

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?

Upvotes: 10

Views: 34906

Answers (1)

Scotch
Scotch

Reputation: 3226

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!

Upvotes: 7

Related Questions