locking a form

[bigmac]

hi all, i have a form called [wqpssub] and i want to unlock it via the locked control in its property controls, this will be acivated if a password is correct after clicking a button, any ideas on the code needed please

 

[Khalid_Afridi]

Hi, what code you are using for the correct password? how do you confirm that the password is correct?
Is your form is subform on main form?

 

[bigmac]

form is a subform the main form is called [profile], as for the password code all i am doing is looking at a text box and comparing answer with a string, example
if me.password = "password" then( its the rest of the code to access the forms locked settings and change it to "yes"

 

[Khalid_Afridi]

The air code should be like this.

Private Sub Command1_Click()
If Me.Password = "password" Then
Me.wqpssub.Enabled = True
Else
Me.wqpssub.Enabled = False
End If
End Sub

It would be better to understand if you could paste your code.

 

[bigmac]

works a treat thanks