Field Lock

[Guest]

Hallo

I hope some one can help i have a combo box and depending what i select from
it it should lock or unlock a field for editing how is that posible

Thank you

Markus

 

[tina]

use an If statement to check the value selected in the combo box, and put it
in the combo box's AfterUpdate event procedure, and also the form's Current
event procedure. the simplest way is probably to identify all the values
that should result in unlocking the other control (the *field* is in the
form's underlying table; you're working with the Locked property of the
*control* that the field is bound to. it helps to use the correct terms.).
example:

If Me!MyComboBox = "something" Or _
Me!MyComboBox = "something else" Then
Me!MyTextBox.Locked = False
Else
Me!MyTextBox.Locked = True
End If

replace the control names above with the correct control names, of course.

hth