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?
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?
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.
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!
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With