How to go to a specific Field using VBA

[Danny0803]

Hello there,

I have a search box that opens a form using a filter. When I type the information I want to search in form, it works fine.
However, I am trying also to add the code that when the new form is open the cursor goes to a specific field in the new form.

Here is the code i have so far:

Private Sub cboSearch_click ()


DoCmd.OpenForm "frmSighOut", acNormal , , "[VehNumber]= ' "Me.txtSearch & " ' "
DoCmd.Close acForm, "frmVehSearch"

End Sub


Please help!!

Thank you,

[ssanfu]

Use

Me.controlName.SetFocus

Change controlName to your control name.

[Danny0803]

Hello there,

I have a search box that opens a form with a subform using a filter. When I type the information I want to search in form, it works fine.
However, I am trying also to add the code that when the new form is open the cursor goes to a specific field in the subform.

Here is the code i have so far:

Private Sub cboSearch_click ()
DoCmd.OpenForm "frmSighOut", acNormal , , "[VehNumber]= ' "Me.txtSearch & " ' "
dDCmd.GoToControl Form!frmSignOut!frmSubSignout.FirstName.SetFocus (I am getting a Error)
DoCmd.Close acForm, "frmVehSearch"

End Sub

I need to add the code to get to the subform.


Please help!!

Thank you,

I am trying to go to the subform, once the main form is opened, and is not working.

I added the following line

[ssanfu]

You didn't have "subform" in the original post.
You have too many "d"s:
dDCmd.GoToControl ............



Try:

Me!frmSubSignout.Form!FirstName.SetFocus