Printout action

[Pauly78]

Can anyone please tell me how i create a macro for my form that when i click will only print certain fields from that particular record?

and would i also be able to specify paper size etc?

Id really appreciate any help as this is the final hurdle to having my database finished.

Thanks in advance

 

[Pauly78]

I think i have figured half of the process out. Ive created a new form, which has only the fields i want to print and the correct layout. Ive created a macro button on my main form that when i click will print the record. It works, but at the moment it prints all records from the start. So i need to have the new form open up displaying the record ID im already looking at on my main database. Can anyone tell me how i can do this? i thought it would have something to do with relationships but i cant create a relationship because both forms take their information from the same table.....

PS i think it might be a case of putting something into the macro filter column??

 

[RogerCooper]

Try creating a query to pull the records and fields you need and print that (or a report based on it).