On Fri, 10 Jul 2009 18:14:10 -0700, 00sherwood
wrote:

I am undertaking a national survey of transport availablility. I have made
up a table containing 189 ID's. (this will eventually go to approximately
9,000 ID's). I wish to extract each ID on a separate page so that I can
fill in the various details of the individual transport company, and then put
each page in a file in alphametical order. I only want one ID per page.
I keep getting one complete ID's details and the first couple of lines of the
next.

What sort of "page"? a Webpage? Or are you trying to do this in Access?

If in Access, you would probably want to use a Form (in Single view) based on
the table, or on a query based on the table (sorted alphabetically by company
name).

Don't confuse data STORAGE (in a table, in no particular order, as fields of
various datatypes) with data DISPLAY (on a page or form, sorted, as textboxes,
combo boxes and other appropriate controls).

--

John W. Vinson [MVP]