Set focus on form based on the form name in control box

[Mario_1955]

Hi, if someone can fix this code below please,
I have the control Txt1 in form1 it has the name of an already opened form2
I need to set the focus on form2 using the form2 name in control Txt1.
I used open form method but it took me to new record while I need it (form2) to stay on the same record.
Thanks.
Private Sub TxT1_Click()


Dim stFrm As String
stFrm = TxT1 '(Control contains the form name)
Forms.stFrm.SetFocus '(I'm having error here)
End Sub

[Gicu]

Have you tried Forms(Me.TxT1).SetFocus (or Forms(stFrm).Setfocus)?

Cheers,

[Bob Fitz]

Hi, if someone can fix this code below please,
I have the control Txt1 in form1 it has the name of an already opened form2
I need to set the focus on form2 using the form2 name in control Txt1.
I used open form method but it took me to new record while I need it (form2) to stay on the same record.
Thanks.
Private Sub TxT1_Click()
Dim stFrm As String
stFrm = TxT1 '(Control contains the form name)
Forms.stFrm.SetFocus '(I'm having error here)
End Sub

Try:
Dim stFrm As String
stFrm = Me.TxT1.Text
Forms(stFrm).Form.SetFocus

[Micron]

umm,

- txt1 contains the name of the form where the focus is to be set and it isn't where the focus is supposed to go?
- you have to give a control the focus before you can get its Text property value
- if a form has enabled controls, you cannot set focus to the form, only to an enabled control?
- Forms(stFrm).Form.SetFocus: I'm not seeing that form2 is a subform, which is kinda what that looks like. Maybe I'm missing that or not understanding that line.