Print record using a report?

jackmac

Registered User.
Local time
Today, 15:00
Joined
Mar 10, 2008
Messages
15
Hi all,

Unusual question possibly. I've created a database for the company I work for which has an input form when the file is opened. There are buttons on the form which allow the user to press them to see a list of records which meet the requirements. (One button says 'Windows' and it shows all of the records with the 'Item' field containing the word 'Windows' - but you get the idea.) The form that prints out is a report I have created which has a signature box at the bottom so the engineer can get the customer to sign to say the job has been completed. What I want to do is have a button which will allow me to use the report form I created but print out say the record I have onscreen at the moment. Can this be done? Any help would be very much appreciated!

I'm using Access 2003

TIA

Jackmac
 
Look at the wherecondition argument of OpenReport in VBA.
 

Users who are viewing this thread

Back
Top Bottom