Nov 1 2006, 08:12 AM
I've recently got the sample database which shows a way to fix columns on a continuous forms type form. The technique however relies on the primary key (or another field) running sequentially from 1 to what ever with no gaps. However, the data I've got does not run sequentially and I want users to be able to sort the form what ever way they want (so the data goes out of sequence).
The only way I can think of doing this is by getting the Line Number of the data in a query but I don't know how to do this.
Does anyone know how to get the line number to appear in a query no matter how it is sorted?
Cheers in advance,
Nov 1 2006, 08:34 AM
I'm sorry, I'm not sure I understand what your are trying to accomplish. If you are attempting to allow your users to sort the continous form anyway they want, take a look at Fancy Sort in Continuous Forms
Nov 1 2006, 08:46 AM
I've got a main form. On that form are 2 sub forms. One subform contains core data (ie. employee number, name etc) which I always want to be in the users view. The other subform contains data from the same table that the user can scroll across. I've used code from a sample database that synchronises the data view on the 2 sub forms so when a user scrolls down the information on the right side the left sub form also scrolls.
However, the problem I've got is the code used in the example assumes an autonumber on the records that runs from 1 to 50. My primary key numbers are not auto number and do not run sequentially so I want to be able to create a query that looks at the line number and runs from 1 to however many records there are. If I then filter the query it will run from 1 to whatever sequentially. It's this bit I'm stuck on.