Printing single record to a report

  • Thread starter Thread starter k.roberts
  • Start date Start date
K

k.roberts

Hi,

I am aware that this topic has been discussed before and I have read
through the advice given, but wanted to explain my problem and
hopefully have someone advise me on how to fix it.

I have set up a tabular form which displays a row of customer visits.
There is a command button next to each row which enables a user to go
to a form for inputting visit information or viewing existing visit
information (this is filtered using the primary key Report ID).

Therefore the form is displayed with all information for that Record
ID. I now wish to place a print button on the form which will send the
record to a preset report called "r_Report template".

What code do I need to place behind the command button to achieve this?
 
Thanks for that code - it worked how I needed it to but I have a
further query. Bit of background info: I have 2 forms on my database
to be filled in by users, info stored in 2 separate tables (slight
difference in some fields though majority of them are identical). The
report that I am using to print the records to is the same for both
however. I use a filter on the record and then a print button to send
the record to the report - this works fine on the data from one form,
but when using the print button on the other, no data is pulled through
- the report stays blank. Do you have any idea why this might happen?
 
Back
Top