Access - create button in a form

[flabergaz]

Access 2000. I'm trying to create a button in a Form that will print the current record through a report. I can print ALL records no problem, but I can't get it to print ONLY the current record. Please help.

[LagMonster]

All we do at work is run a query and Inlude all the fields. Works great!
If you need more help let us know.

[jeffsr]

There are a couple of ways to go about doing this. But, basically you have to have a unique field in the report that identifies each record in the database as being unique. You can create a command button and attach a macro to it, you can try the control wizard (unlikely to get you what you want), or you can write an event procedure to activate the report with the current record as being the object of focus, when the button is clicked. Good luck and learning Acces basic can be fun..

------------------
Jeff Lawrence

[This message has been edited by jeffsr (edited March 09, 2001).]

[Nuce007]

just open the form in design view. Then on the toolbox(view--> toolbox if you dont see it) choose the command button which will open a wizard. In the wizard goto record operations and select print record, this will print the record.

if you want to do this with a report just make a query that produces the results.
Go to reports, choose new, report wizard, select the query and move over the fields you want. now on the form follow choose the command button and then report operations. Print Report, choose the report you just created and your done. hope this helps some....