[AccessD] A2K: Go to Record on Subform

NO ARCHIVE
Thanks Andy
That was it
Good luck with A2K
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 5:17 PM
Subject: RE: [AccessD] A2K: Go to Record on Subform


> 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
> > 
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com