check box with password

[Guest]

Hello All, I need some help, please. In form I've got a combo box with user
names. After the user selects its own name, he has to click a check box. When
the user clicks it, a password is required to allow the update (the password
form I copied from this community). If the password is incorrect, the check
box remains unchecked. Everything is working, but the problem is that when
the check box is updated, the user can go back to the combo box and change
the user name. Is that a way of avoiding that after the checkbox is checked?

 

[Keith Wilby]

Hello All, I need some help, please. In form I've got a combo box with
user
names. After the user selects its own name, he has to click a check box.
When
the user clicks it, a password is required to allow the update (the
password
form I copied from this community). If the password is incorrect, the
check
box remains unchecked. Everything is working, but the problem is that when
the check box is updated, the user can go back to the combo box and change
the user name. Is that a way of avoiding that after the checkbox is
checked?

Disable the combo control in the After Update event of the checkbox and in
the Current event of the form (untested code follows).

If Me.chkMycheckBox Then
Me.cboMyCombo.Enabled = False
Else
Me.cboMyCombo.Enabled = True
End If

Keith.
www.keithwilby.com

 

[Guest]

Tks for the reply, but let me explain better the situation, because I tried
that and for every record the combo box was locked at the end.
I trying to do something like that: I've got different references number for
a series of records. I've got also a combo box with some names. My check box
ckecks the names and opens a password form. Lets supose that for the
reference number 1 I have the name John in the combo box. John enters his
password and after updated the check box is checked. Then I want the combo
box to be locked because John did that. For the reference number 2, another
person, Julie, have to do the same, so she needs the combo box available for
that, and so on.
Is that another way of doing that? If you need more clarification I can post
the code that I used.
Thanks again
Regards