I want to have a button on a form so that the form using only the current record is printed out. Can someone please help me.
Thanks.

If you are wanting to print out the form containing only the current record in form view then you can attach a simple macro to a command button on the form.

In your macro set the action to PrintOut, and in the action argumants set the Print Range to "Selection".

HTH

You will find the wizard will help you with this when you put a command button in your design. One thing though, if you put a button on a form and print the form it will include the button as well.

You can set your command buttons Properties>Format>Display When: Screen Only

Or use the SetValue Action to make the command button not visible when printing the form, and set visibility back on completion of printing.

Graham

David - saw your reply after I had submitted mine.

It's amazing how we sometimes miss the *easy* solutions.

[This message has been edited by Graham T (edited 01-30-2002).]

*grin* One of the benefits of starting new (6 months ago never seen MS Access) is that you don't learn all the bad habits.

NOT to say that coding is a bad habit, but sometimes there are simpler ways.