[AccessD] A2K: Go to Record on Subform

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
> 



More information about the AccessD mailing list