T
TM
I would like to create a source file for a report. A
form/table contains the main data, however the user is
selecting customers from a list box which he will send
the report to. I need to create a source for the report
from this list box and have the report keep the same data
on each page, changing only the customer. I want the
report to either open for review or print once the user
selects the customers and clicks a button.
I am "toying" with several ideas, but am not sure which
would be best. I am open for input! I am thinking of
creating a table holding the customer names and using an
sql statement on open of the report to get the "main"
data. Or, just open the report with each selection. Any
suggestions?
Sorry if this is a duplicate post, I tried posting this
earlier today, and have not found my post on here as yet!
THANKS!
form/table contains the main data, however the user is
selecting customers from a list box which he will send
the report to. I need to create a source for the report
from this list box and have the report keep the same data
on each page, changing only the customer. I want the
report to either open for review or print once the user
selects the customers and clicks a button.
I am "toying" with several ideas, but am not sure which
would be best. I am open for input! I am thinking of
creating a table holding the customer names and using an
sql statement on open of the report to get the "main"
data. Or, just open the report with each selection. Any
suggestions?
Sorry if this is a duplicate post, I tried posting this
earlier today, and have not found my post on here as yet!
THANKS!