Printing form data through a report via a command button

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This is probably a basic issue...I just have not had success looking it up in
past questions.

I have a basic, no frills form. I want to assign a command button to the
form that prints the information on that form in a report. I have constructed
a report based on a query that will print the data; my issue is the best way
to deliver the key parameter (in this case, account number) from the data
currently on the form to the query which triggers the report. I think I see a
couple of options:

* Pass the account number to the query, then generate the report
* Update the table underneath the form, then have the report print the last
entry in the table.

Would one of these options be the best, or is there a better way?
 
One word:

Sweet.

Thanks.
--
Robert Robinson


Allen Browne said:
See:
Print the record in the form
at:
http://allenbrowne.com/casu-15.html

The article explains how to use the WhereCondition of OpenReport, so you
don't need to change your query or table.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

message
 
Back
Top