Report for single customer from form

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

I currently have a form set up viewing each customers
information independantly
How can I add a button to create a report for that
customers details and related details?
I am reasonably new to access and any advice would be
appreciated.

Thanks

Mark
 
Mark said:
I currently have a form set up viewing each customers
information independantly
How can I add a button to create a report for that
customers details and related details?
I am reasonably new to access and any advice would be
appreciated.
Click to expand...


There are several ways to do this. Probably the easiest for
a beginner to understand is to base the report an a query
where the customer ID field has a criteria of the style:

Forms!theform.customerIDtexbox

A somewhat better way is to use the button wizard for print
a report, then modify the wizard generated Click event
procedure to use the OpenReport method's WhereCondition
argument (see Help for details).
 
Back
Top