SteveL13
asked on
How open form in read-only mode but allow combo-box to work to search for a record
I have a form opening in read-only mode via this code in the onclick event of a command button on a first form:
But then the combobox I am providing on the form for the user to find a record that opens in read-only mode seems to be locked also. Is there a way to make the form open in read-only mode but allow the combobox to work?
If DLookup("[SecurityLevel]", "LOCALtblCurrentUser") = 2 Or 3 Then
DoCmd.OpenForm "frmDrawingControlHeader", acNormal, , , acFormReadOnly, acWindowNormal
End If
But then the combobox I am providing on the form for the user to find a record that opens in read-only mode seems to be locked also. Is there a way to make the form open in read-only mode but allow the combobox to work?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.