refer to control on parent form

[rodmc]

Im having a little trouble referring to a control on a parent form as you can see from the code below, in particular the setfocus line

Private Sub cboPrim_Reason_AfterUpdate()
    If Me.cboPrim_Reason = "Mental Health - Other" Then
        MsgBox "If you select Mental Health - Other then you must add the reason to the Notes field!", vbOKOnly, "Warning!"
        Me.Parent.txtNotes.SetFocus
    End If
    
End Sub

clearly my reference is wrong, can someone correct for me

cheers

 

[spikepl]

Clearly? Hrmpf....

For references to items on another form - create a textbox on the same form. Open the property sheet, and in Control Source click the ellipses. Navigate to the desired item (amon Loaded forms) in the expression builder, click paste and OK. Now you have a reference you can paste where you need it.

 

[rodmc]

cheers bud!