I have an application where a good portion of a report is created dynamically
and automatically for the end user.  The end user may need to tweak the
report design by moving fields around or adding new text boxes that prompt
for information not stored in a table, but that the end user wants displayed
on the report.  Using a form for the prompt information is not an option in
this case, because the end user is not familiar with changing forms and would
not be adept at changing both a form AND a report when the report output
requires a change.

In some cases the end user wants to add numerous prompt fields to the
report, some of which are related in content.   The order in which the
prompts pop up at run-time, however, seems random.  Is there any way to
dictate the order in which the prompts appear?  I have tried naming the text
boxes alphabetically, but that does not work.
Thanks.
Kathy