help with unlocking a combo box

  • Thread starter Thread starter jln via AccessMonster.com
  • Start date Start date
J

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.
 
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
 
Back
Top