I know this should be easy but I haven't done this in a while.
I want to set the Focus to a Field on an underlying form by passing a ComboBox Value on a form called frmDvdFind. It has the ComboBox and a Command Button
The ComboBox's Row Source is a table.
This form is called from the underlying form.
After selecting a row in the combo box I want to be able to press the command button and set the focus to a field on the underlying form but I'm not having any luck,
The error says it can't find the field vCbo.
This must be second nature to most but not to me,
James
I want to set the Focus to a Field on an underlying form by passing a ComboBox Value on a form called frmDvdFind. It has the ComboBox and a Command Button
The ComboBox's Row Source is a table.
This form is called from the underlying form.
After selecting a row in the combo box I want to be able to press the command button and set the focus to a field on the underlying form but I'm not having any luck,
Code:
Private Sub cmdFind_Click()
Dim vCbo As String
vCbo = "Me!cboFieldName.Value"
Forms!frmDvd!vCbo.SetFocus
End Sub
The error says it can't find the field vCbo.
This must be second nature to most but not to me,
James