[AccessD] A2K: Go to Record on Subform

Darren DICK d.dick at uws.edu.au
Mon Jul 7 01:39:23 CDT 2003


Hello all
I have a subform on my main form (frmMain) called MySubForm
But I don't want the Nav Buttons on the subform Visible. So ...I wanna set up generic navigation buttons
on frmMain

The gotcha is MySubForm dot SourceObject will vary between 3 forms designed to be sub forms.
EG sub_frm_Suppliers, sub_frm_Products and sub_frm_Categories.
So depending if the user clicks the Categories, Suppliers or Product buttons on frmMain the 
MySubForm dot SourceoObject will equal the relative button clicked.

Then I want the generic Nav Buttons on the Main form to control the record movement on the sub form

Clear as mud :-))

Any suggestions on syntax??

Many thanks in advance

Darren



More information about the AccessD mailing list