Print single input for from table

[00sherwood]

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.

 

[John W. Vinson]

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).