Combo box locked unless unlock button selected

[Jake F]

I have a form that locks the records when you open it and you hit an unlock
button to allow editing, adding, or deleting. The problem is I have a combo
box to go to a specific record and the combo box doesn't work if the records
are in lock mode. However I made some navigation buttons and i can move
through the records that way when they're locked. Do I need to code
something in for the combo box on click? Thanks.

 

[Beetle]

Presumably, there is some code behind your form that locks the controls.
You'll need to find the code and either remove the combo box from the group
of controls that get locked, or add another line to unlock it

 

[Jake F]

I have the form set to not allow edits in the properties so what would i code
in to unlock the combo box? I'm assuming it'd be on load or on open?

 

[Beetle]

Actually, it should have occurred to me that you might be using the
AllowEdits property (duh). Unlocking a control via code won't override the
AllowEdits property, so it will have to be done some other way.

If you don't have a ton of controls on your form, then instead of using
AllowEdits, you could programatically lock/unlock certain controls. You could
create one procedure to lock them and another to unlock them, then just call
the procedures from different events get the effect you want from your form.

If you do have a lot of controls, then this could be a lot of work. Maybe
someone else here will respond with a better idea.