help with unlocking a combo box

[jln via AccessMonster.com]

Here is what i have. I have records that once they are saved i need the combo
box locked , but when the create a new record button is pushed the combo box
unlocks and allows for something to be selected. and then lock once the new
record is saved.

 

[John Spencer]

In the On current event of the form, you would need something like the
following

If Me.NewRecord then
Me.Combobox.Locked = False
Else
Me.Combobox.Locked = True
End if


In the button New Button record you might need to include
Me.Combobox.Locked = False