Turn control to read only when editing but write when adding

[Guest]

I have a control that is a look up to find a value. I want to make the
control read only if the record is being edited and allow it to be changed
when a new record is added? How do you do that?

 

[Allen Browne]

Use the Current event of the form to lock the control if you are not at the
new record:

Private Sub Form_Current()
Me.[NameOfYourControlHere].Locked = Not Me.NewRecord
End Sub

 

[Guest]

Thanks!!!!

Use the Current event of the form to lock the control if you are not at the
new record:

Private Sub Form_Current()
Me.[NameOfYourControlHere].Locked = Not Me.NewRecord
End Sub

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I have a control that is a look up to find a value. I want to make the
control read only if the record is being edited and allow it to be changed
when a new record is added? How do you do that?