Avatar of sirbounty
sirbountyFlag for United States of America

asked on 

Access form entry - 'locked' field?

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.
Microsoft Access

Avatar of undefined
Last Comment
Jim Dettman (EE MVE)
Avatar of Ryan Chong
Ryan Chong
Flag of Singapore image

 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?
Avatar of sirbounty
sirbounty
Flag of United States of America image

ASKER

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.

Jim.
Avatar of sirbounty
sirbounty
Flag of United States of America image

ASKER

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.

Still unable to edit that one and only field. 
ASKER CERTIFIED SOLUTION
Avatar of sirbounty
sirbounty
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Excellent.  

Jim.
Microsoft Access
Microsoft Access

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.

226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo