need to print 1 record from db

[cxfrench]

i have a small program setup with 1 table and 1 query i also have 1 form setup and 1 report and 1 macro and what i would like to do is be able to print 1 record from my database so when i go in i go to my form and i can scroll through all my record (390) but then i have a print button on there as well and when i print it every record from the database gets print when i only want the record that i'm currently looking and to print

if anyone knows please reply

 

[AncientOne]

In form design view, when you use the toolbox to add a command button, you get a wizard offering you a choice of what the button should do. One of the Options under Form Operations is "Print Current Form". Another , under Record Operations is "Print Record."

If you want to print just one record as a report, create a report based on a query with Record Number (or whatever your Primary Key is called)as a parameter . Then you just type in the number of the record you want printed

 

[Ade F]

Solution 2

please see

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=49231

Hope this helps

Regards

Adrian