Multiple records in Form

[JonnyB]

Hi,

I am trying to display 25 records on a form, but I want the user to be able to page through these records in blocks of 25 (not one at a time)

I have tried using the tabular control in conjunction with a command button and incrementing through records using For Next Loop, but this still allows the user to scroll through one at a time, and I don’t think this is the way I should be approaching this.

OK:

After doing a bit more research I realise that I need to pass some values from my Form to the Query, so that the query can return the required set of records.

How do I pass a value from a command button to my query?


In addition to this I need to keep tract of the current page number (which batch of 25 records are they looking at) i.e. page 5 would be displaying records 100 – 125.

Any pointers in the right direction would be greatly appreciated,

Cheers,

Jon

 

[gemma-the-husky]

i actually think this is an unnatural way of proceeding.

I think it resembles the sort of approach you might use in 3GL languages on fixed screen platforms.

But Access manages the whole set of data independently, fitting whatever it can into available screen space - eg increase the size of the window on the screen, you see more records, decrease it, you see less, and it manages the file start/end conditions without you having to do anything

 

[JonnyB]

Hi Gemma,

Thanks for your reply, I understand that its an odd thing I am trying to achieve, however the data needs to be broken down into manageable chunks (less than 50 rows) so that it can be analysed. I guess it would not matter if the form were to change size, thus changing the number of rows displayed so long as I could store the start and end record id’s that relate to the data being displayed on the screen.