I have a form for my data entry with one field as a multi-select combo that has 5 or so options from an entered value list lookup.
When I'm entering data into the form, it does not allow me to type, nor select, any data in this field. It's enabled and not locked, so I'm not certain what else to check?
I'm not really certain what other information may be needed - I haven't worked with Access in ages - but feel free to ask and I'll provide further details.
It's enabled and not locked, so I'm not certain what else to check?
If the control's properties is not set as Locked and Enabled = False but it appears that it is. I guess probably some VBA codes have changed the control properties dynamically?
hence, try verify if there's any codes in Form_Load or Form_Current event that changed the control's property?
I suppose I should point out, I'm using the contact template to build everything from. This was a field that I changed to multi-select. There is some slight vba code, but nothing that would prevent me from selecting data in this field.
1. Check the AllowEdits property of the form is true 2. Check that the data the form is based on is editable. Open it's recordsource directly and see if you can edit the fields.
And welcome back to Access....haven't seen your name in quite some time.
Thanks Jim. I neglected also to mention the version! Sorry about that... O365 (v 2004 - build 12730.20236).
For AllowEdits, I can edit other fields, so even though I can't locate that property, I'm assuming it's true? I have Allow Form view, datasheet & layout view (bookends are set to yes).
In the datasource, the field is set to a short text data type. Since this is built off of the contacts template, I do have an order by field that is probably invalid, so I removed that. I can edit outside of the form, no problem. The lookup tab has allow multiple values, limit to list, allow value list edits all set to Yes.
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.
If the control's properties is not set as Locked and Enabled = False but it appears that it is. I guess probably some VBA codes have changed the control properties dynamically?
hence, try verify if there's any codes in Form_Load or Form_Current event that changed the control's property?