Access forms

[waynered]

I have inserted a command button on an Access form to print the current record on the form but it prints every record in the table.

Please help...

Wayne

 

[Joe4]

You will probably have better luck asking this question an Access site. Try

http://www.accessvba.com/

 

[ldmccracken]

I would be tempted to Print a report rather than a form then set a filter to get the single record to print

DoCmd.OpenReport "HCLetter01", acPreview, , Me.Filter

Change the 'preview' after testing.