Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
movenext form a second form 2
- Thread starter jeffmoore
- Start date
-
2
- #2
- Thread starter
- #3
okay but my form A is a sub form....
DoCmd.GoToRecord acDataForm, "[forms]![frm_training_matrix]![qry_training_details_sub subform]", acNext
and the above syntax give me the error ..." form "[forms]![frm_training_matrix]![qry_training_details_sub subform]" isn't open .... yet it is
DoCmd.GoToRecord acDataForm, "[forms]![frm_training_matrix]![qry_training_details_sub subform]", acNext
and the above syntax give me the error ..." form "[forms]![frm_training_matrix]![qry_training_details_sub subform]" isn't open .... yet it is
Should have said that, completely different animals;-)
Set focus to it first, then issue the command without objecttype and objectname arguements.
[tt]me![qry_training_details_sub subform].setfocus
docmd.gotorecord,,acnext[/tt]
- note, this requires that the subform name and the subform control name is the same, else be sure you're using the latter.
Roy-Vidar
Set focus to it first, then issue the command without objecttype and objectname arguements.
[tt]me![qry_training_details_sub subform].setfocus
docmd.gotorecord,,acnext[/tt]
- note, this requires that the subform name and the subform control name is the same, else be sure you're using the latter.
Roy-Vidar
- Thread starter
- #5
Is the subform control name txt_testtype, then use it in the reference. If the txt_testtype is the name of a control on the subform, let's forget it for the time being.
A subform isn't recognized as an open form, it exists as a control on the main form (together with text controls, combo controls...). When referencing subforms, and controls on a subform, one must refer using the subform control name, which may differ from the subform name as viewed in the database window. Here's some info from Microsoft How to refer to a control on a subform or subreport in Access 2000.
If my above suggestion doesn't work, eaasiest way of obtaining the correct subform control name, is to enter a control on the main form, then use the expression builder to doubleclick thru forms, loaded forms, main form, subform and a control on the subform. The resulting reference will contain the correct reference to use...
Roy-Vidar
A subform isn't recognized as an open form, it exists as a control on the main form (together with text controls, combo controls...). When referencing subforms, and controls on a subform, one must refer using the subform control name, which may differ from the subform name as viewed in the database window. Here's some info from Microsoft How to refer to a control on a subform or subreport in Access 2000.
If my above suggestion doesn't work, eaasiest way of obtaining the correct subform control name, is to enter a control on the main form, then use the expression builder to doubleclick thru forms, loaded forms, main form, subform and a control on the subform. The resulting reference will contain the correct reference to use...
Roy-Vidar
- Thread starter
- #7
- Thread starter
- #8
- Status
Similar threads
- Locked
- Question
- Locked
- Helpful tip
- Locked
- Question
