Hide Focus with Control Error

[HD20]

I have read the threads on this subject and I thought I had my coding fixed, but obviously not, beacause I still get the error, "You can't hide a control that has the focus". Maybe it is a form/subform thing.

Here is my code:

Private Sub txtAge_AfterUpdate()
If Me.txtAge > 39 Then
Me!subfrmVersion.Form.chkWellness.Visible = False
End If
End Sub


txtAge is on the main form and chkWellness is on the subform.

Any help would be appreciated.

 

[daveUK]

The syntax for referencing a subform is

Form!MainForm!Subform.Form.ControlName

so for your database it would be

Form!NameOfMainForm!subfrmVersion.Form.chkWellness.Visible = False

HTH

 

[HD20]

Now I am getting the error, "Microsoft can't find the field 'frmData' referred to in your expression.

frmData is my Main Form.

This is my syntax:
Form!frmData!subfrmVersion.Form.chkWellness.Visible = False

Did I misunderstand your reply and put it in wrong?