Jerry Stoner
03-14-2002, 06:04 AM
Im trying to go to a new record in a subform from another subform on the main form.
Main form - frmDataEntry
Subform Im in - frmGeneric
Subform I want to move to new record - frmBrand
DoCmd.GoToControl "frmBrand"
DoCmd.GoToRecord ,, acNewRecord
What is the correct syntax to use in the GoToControl Command?
Also tried DoCmd.GoToRecord Me!Parent."frmBrand" and about a hundred variations to no avail. A search of the archives was no help.
Main form - frmDataEntry
Subform Im in - frmGeneric
Subform I want to move to new record - frmBrand
DoCmd.GoToControl "frmBrand"
DoCmd.GoToRecord ,, acNewRecord
What is the correct syntax to use in the GoToControl Command?
Also tried DoCmd.GoToRecord Me!Parent."frmBrand" and about a hundred variations to no avail. A search of the archives was no help.