Read Only Form with Editable Field

[unclefink]

I have a form that is being opened by a button with a vba command as followed.

Private Sub Command33_Click()
DoCmd.OpenForm "caseedit", , , , acFormReadOnly
End Sub

One of the fields in the form is a combo box that the user can choose an associated number to each field and open the data for that field.

What I want to do is have the form open in read only with an exception of that one field and if changes to a specific field in a record needs to be edited the user can push a button that makes that data editable. How would I go about doing this.

The form name is caseedit, and the field I want to have editable at all times is named combo26.

Thanks in advance for any help anyone may be able to provide.

Respectfully,

 

[Estuardo]

G'd evening,
Access doesn't work that way. acFormReadOnly is just that. What you can do is to disable all controls (by hand or a controls loop) and let just that one combobox enabled.
G'd luck

 

[JHB]

What I want to do is have the form open in read only with an exception of that one field and if changes to a specific field in a record needs to be edited the user can push a button that makes that data editable. How would I go about doing this.

Try the below code:

Private Sub combo26_Enter()
  Me.AllowEdits = True
End Sub
Private Sub combo26_Exit(Cancel As Integer)
  Me.AllowEdits = False
End Sub