Tab index with Tab Control

[Gator]

I have a Main form with a textbox control and a Tab Control below that
contains a subform, in datasheet view, on one of the tabs. I want to enter a
date in the textbox on the Main form and then press either tab or enter and
the focus goes to the subform's first record. What's happening is when I
enter the date on the Main form and press tab or enter, the Main form starts
a new record. I've been trying to set the tab indexes on the form's
properties window. Is it easier to do this in code? How would the code read?

 

[Ryan]

Private Sub DateTextbox_LostFocus()
DoCmd.GoToControl "[Forms]![YourSubformName].[YourFieldName]"
End Sub

A way to prevent going to a new record is to go to the properties of the
form, then to the other tab and changing Cycle to Current Record

 

[Gator]

I get a runtime error 2109----
"There is no field named 'MySubformName.MyFieldName' in the current record.
--
Gator

Private Sub DateTextbox_LostFocus()
DoCmd.GoToControl "[Forms]![YourSubformName].[YourFieldName]"
End Sub

A way to prevent going to a new record is to go to the properties of the
form, then to the other tab and changing Cycle to Current Record
--
Please remember to mark this as answered if this solves your problem.

I have a Main form with a textbox control and a Tab Control below that
contains a subform, in datasheet view, on one of the tabs. I want to enter a
date in the textbox on the Main form and then press either tab or enter and
the focus goes to the subform's first record. What's happening is when I
enter the date on the Main form and press tab or enter, the Main form starts
a new record. I've been trying to set the tab indexes on the form's
properties window. Is it easier to do this in code? How would the code read?

 

[Douglas J. Steele]

Ryan's information was incorrect.

You cannot refer directly to a form being used as a subform in that manner:
subforms aren't actually in the Forms collection. Instead, you have to refer
to it via the subform control on the parent form.

Assuming that that code is associated with the parent form, you'd use

Me!NameOfSubformControl.Form!NameOfField

If it's somewhere else, you'd use

Forms!NameOfParentForm!NameOfSubformControl.Form!NameOfField

Note that depending on how you added the subform to the parent form, the
name of the subform control may be different than the name of the form being
used as a subform.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I get a runtime error 2109----
"There is no field named 'MySubformName.MyFieldName' in the current
record.
--
Gator

Private Sub DateTextbox_LostFocus()
DoCmd.GoToControl "[Forms]![YourSubformName].[YourFieldName]"
End Sub

A way to prevent going to a new record is to go to the properties of the
form, then to the other tab and changing Cycle to Current Record
--
Please remember to mark this as answered if this solves your problem.

I have a Main form with a textbox control and a Tab Control below that
contains a subform, in datasheet view, on one of the tabs. I want to
enter a
date in the textbox on the Main form and then press either tab or enter
and
the focus goes to the subform's first record. What's happening is when
I
enter the date on the Main form and press tab or enter, the Main form
starts
a new record. I've been trying to set the tab indexes on the form's
properties window. Is it easier to do this in code? How would the
code read?