form page number on continuous form

[Stephen]

I was looking at article 210336 (ACC2000: Sample Function to Determine
Current Page of a Form) and is doens' appear to do what i am trying to
accomplish.

I have a continuous form, of which teh user can see 12 records at a time.
For certain user issues, the verticle scroll bar cannot be used. However, I
need for teh user to still be able to scroll/advance through the records.

I have tried the DoCmd.RunCommand acCmdRecordsGoToPrevious and
DoCmd.RunCommand acCmdRecordsGoToNext commands, but it is dependednt on the
current cursor position. Hence, the user has to click 13 times to get to
the bottom of the window and the move that way.

I also tried to make it so that when teh user clieck teh advance button, it
will run DoCmd.RunCommand acCmdRecordsGoToPrevious 12 times to egt to the
next record. However, this is all very "choppy" and has lots of problems
taht arise.

Is tehre another way of having the "advance button" move the form from page
1 (records 1-12) to page 2 (record 13-24) and tehn to page 3 (25-36),
etc....?
Would it need to change the forms recordsource to "SELECT 13-24 FROM ..."
Is that possible?

-Stephen

 

[Cheryl Fischer]

Stephen,

Sorry I don't have any specific code available to pass on to you, but I
think you can get what you want by playing around with DoCmd.GoToRecord,
which has arguments which will allow you to move forward or back by a
specific number of records or to move to a specific record #.


hth,

 

[Stephen Lebans]

Hi Cheryl,
you can use the SelTop property to programmatically manipulate the
scroll bar/record position.
http://www.lebans.com/setgetsb.htm

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[Cheryl Fischer]

Thanks, Stephen!