Form with continuous scrolling fields to show data changes

[Richard-S]

The object is to have a form with a scrolling list of rows that does only scrolling. The purpose of this is to show an audience data changes over time. I was able to make a scrolling form using a query that was based on a time change with a requery and timer, but that is to show only the current 10 most recent changes. That form worked well.



However, I am unable to think of a way to maintain the original order of a table to only move the order up one and keep scrolling going from 1 through end# then back to 1 and continue that scrolling indefinitely. The screen shows 10-12 rows at a time so the screen should show 1-10, then 2-11, then 3-11 and so on until there is a screen showing 20-25 and 1-5, for example. Also 20-25(end) then next time 1-10 would also work. They would like to see all 10 auction items, but if that does not work, then whatever can work to show as many as possible will be acceptable.

Background: This form is to be part of an auction process that has bidders using networked computers to make bids. One large screen would be used to show auction items and their status, such as description, an image, current amount bid and bidder number. Instead of a typical auction showing one item at a time, this auction is all items being offered at once with a future closing time for all.

[ranman256]

A continuous form shows the list of items.
You will need a date stamp field to show the list in order of change. It doesnt need filled in, just set the field to DEFAULT = NOW() , and Access will fill it in.
(be sure the field data format = general date)

[Richard-S]

Thanks, that helped showing changes to the timed order of changes being made.