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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Refresh the data in dropdown combo box 7
Combo box locked unless unlock button selected 3
Access Form - Lock Fields from Editing 0
populate a text box with multiple records based on combo box selec 2
flexibility in searching by adding “search by†combo box 1
Code to populate combo box 1
Run query to feed combo box 2
Unprotect Combo Box in a Protected Sheet 3

Back
Top