Link to home
Start Free TrialLog in
Avatar of SteveL13
SteveL13Flag for United States of America

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:

    If DLookup("[SecurityLevel]", "LOCALtblCurrentUser") = 2 Or 3 Then
        DoCmd.OpenForm "frmDrawingControlHeader", acNormal, , , acFormReadOnly, acWindowNormal
    End If

Open in new window


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
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial