Andy Lacey
andy at minstersystems.co.uk
Mon Jul 7 02:17:13 CDT 2003
Darren You may need a line that goes: rst.bookmark = Me.subFormControlName.Form.BookMark straight after the Set. Andy Lacey http://www.minstersystems.co.uk > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darren DICK > Sent: 07 July 2003 08:09 > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] A2K: Go to Record on Subform > > > Hi Andy > Life is great (Except when I have to work on Access stuff) > It kinda works > When I click for first time to go to next rec All is OK. > Then click Second time - nothing happens > Then click third time it goes to 2nd Rec. > Then click third time it goes to Rec 3 > The every click thereafter goes between rec 2 and rec 3?? > Buggered if I know > > Any other suggestions gratefully appreciated > > Darren > > > ----- Original Message ----- > From: "Andy Lacey" <andy at minstersystems.co.uk> > To: "'Access Developers discussion and problem solving'" > <accessd at databaseadvisors.com> > Sent: Monday, July 07, 2003 4:47 PM > Subject: RE: [AccessD] A2K: Go to Record on Subform > > > > Hiya Darren. How're you doing? > > > > My suggestion on this would be to use the RecordsetClone of the > > subform. This sort of thing: > > > > Dim rst as Recordset > > > > Set rst = Me.subFormControlName.Form.RecordSetClone > > rst.moveNext > > Me.subFormControlName.Form.BookMark=rst.Bookmark > > rst.close: set rst=nothing > > > > You're going to need error handling to look after there being no > > records, or already being on the last record. You can also > set this up > > as a single function and pass a param to say which move you want to > > do. > > > > But someone may well have a simpler solution. > > > > See ya. > > > > Andy Lacey > > http://www.minstersystems.co.uk > > > > > > > > > > > > > > > > > -----Original Message----- > > > From: accessd-bounces at databaseadvisors.com > > > [mailto:accessd-bounces at databaseadvisors.com] On Behalf > Of Darren DICK > > > Sent: 07 July 2003 07:39 > > > To: Access Developers discussion and problem solving > > > Subject: [AccessD] A2K: Go to Record on Subform > > > > > > > > > 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 > > > > > > _______________________________________________ > > > AccessD mailing list > > > AccessD at databaseadvisors.com > > > http://databaseadvisors.com/mailman/listinfo/a> ccessd > > > Website: > > > http://www.databaseadvisors.com > > > > > > > _______________________________________________ > > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/accessd > > Website: http://www.databaseadvisors.com > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/a> ccessd > Website: > http://www.databaseadvisors.com >