Locking a combo box

[Stanley]

I set a combo box to enabled yes and locked no and I have no problems picking
a value. My combo box is bound to a table. The problem is I can type over the
value in the combo box and change the value in the table.
I would like to pick a value and subsequently like lock the combo box.
Thanks,
Stanley

 

[Dennis]

Stanly,

If you lock the combo box once the user has entered data, how will they ever
correct it?

Given that, you might try this. I don't know if it will work.

on the field's Got Focus event, add this code:

If inNull(ComboBoxDataFieldNm) then
me.cboCtlNm.Enabled = True
me.cboCtlNm.Locked = False
else
me.cboCtlNm.Enabled = False
me.cboCtlNm.Locked = True
end if

on the field's Lost Focus event, add this code:

me.cboCtlNm.Enabled = True
me.cboCtlNm.Locked = False



I don't know if that will work, I would give it a try.

 

[Marshall Barton]

I set a combo box to enabled yes and locked no and I have no problems picking
a value. My combo box is bound to a table. The problem is I can type over the
value in the combo box and change the value in the table.
I would like to pick a value and subsequently like lock the combo box.

Use code in the form's AfterUpdate event to lock the combo
box:

Me.thecombobox.Locked = Not IsNull(Me.thecombobox)

What is a user supposed to do if the wrong value was picked?

 

[Linq Adams via AccessMonster.com]

As has already been noted, your proposed scenario has a problem in that users
do make mistakes, especially when picking a value from a combobox while in a
hurry, and locking the cbo prevents them from correcting their mistake.

You also mention a user typing over an existing value and changing it in the
underlying table, but make no mention of them using the combobox to change a
previous selection.

Is it simply the typing in of a different value, one not in the combobox that
you want to prevent? There are several ways to do this. One would be to

1) Add a textbox to your form and bind it to the underlying field, not the
combobox

2) In the textbox properties sheet, set Locked Property to Yes

3) Use code like this in the cbo's AfterUpdate event:

Private Sub YourComboName_AfterUpdate()
Me.TargetTextBox = Me.YourComboName
End Sub

The data in the TargetTextBox cannot be overwritten by the user, but they can
remedy a mistake made with the cbo by making another selection.

 

[Dennis]

Marshal,

I'm still learning Access, so please permit a couple of questions from a
student. I understand placing the code you suggested in the form's After
Update event. Here are my questions:

1. What happens when the user goes to enter the next "transaction" during
the same session? The combo box will have been disabled by the Form's After
update so they will not be able to enter anything in the combo box for the
next or subsequent transations in that session.

2. What happens the next time the user enters the form in a different data
entry session and the first thing they pulls up is a prior transations?
Since the Form's After Update has not yet run, they will be able to change
the value in the combo box.

Thanks for the information.

 

[Douglas J. Steele]

Same answer to both questions.

Whatever logic you've got in the AfterUpdate event needs to be invoked in
the form's Current event so that as you move from row to row in the form,
Access determines whether or not the current row needs to have its combo box
locked or not.