<div>
Set the Locked property of all of the controls (except the combo) to Yes, then you can open the form in regular mode and the user will not be able to make edits, but the combo box will work.
</div>


Set the Locked property of all of the controls (except the combo) to Yes, then you can open the form in regular mode and the user will not be able to make edits, but the combo box will work.

<div>
Is there a way to set the locked property to Yes in the on open event overall or do I have to set them each individually?
</div>


Is there a way to set the locked property to Yes in the on open event overall or do I have to set them each individually?

SteveL13

<div>
<div class="content wysiwyg-content">
I have a form opening in read-only mode. &nbsp;That is a change I just made. &nbsp;On that form is a combo box that allows the user to select a record and then the form used to display that selected record before I made the form read-only. &nbsp;But since the form is read-only, the combo box doesn't work. &nbsp;Is there a way to allow the user to use the combo box even though the form is read only?
</div>
</div>


I have a form opening in read-only mode.  That is a change I just made.  On that form is a combo box that allows the user to select a record and then the form used to display that selected record before I made the form read-only.  But since the form is read-only, the combo box doesn't work.  Is there a way to allow the user to use the combo box even though the form is read only?

Read-only form behaviour

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.