Print current record

[kpons]

I can't figure out how to print only the current record...My "form" is where the user enters data to make a receipt and so far I can make the command to print and in triplicate as required, but it prints every single record and I only want the current one...help
thanks

[mshmyob]

Put a condition in your Query that equals say your primary key of the form.

I can't figure out how to print only the current record...My "form" is where the user enters data to make a receipt and so far I can make the command to print and in triplicate as required, but it prints every single record and I only want the current one...help
thanks

[ADezii]

I can't figure out how to print only the current record...My "form" is where the user enters data to make a receipt and so far I can make the command to print and in triplicate as required, but it prints every single record and I only want the current one...help
thanks

• Printing the Current Record on a Form is a simple 2-Step process:
  1. Select the Current Record.
  2. Print only the Selected/Current Record by using the PrintOut Method and setting its printrange Argument to the Selected Record.
  3. The code would be:
     [CODE=vb]DoCmd.RunComman d acCmdSelectReco rd
     DoCmd.PrintOut acSelection[/CODE]
• Let me know how you make out.