Access Print

Reply Subscribe

Thread Tools

Search this Thread

24 May 2002, 10:24 AM

Trotty

Scooby Regular

Thread Starter

Join Date: Feb 2002

Posts: 179

Likes: 0

Received 0 Likes on 0 Posts

Hi all,

Got what will probably be a very simple problem here...
I've got a user who's creating an employee db in Access 2000. It's only basic but he's got a 'lil command button on the form which he wants to use to print the current record only - at the moment we're using:

DoCmd.PrintOut

but that prints all records! Don't know Access unfortunately and can't quite work out how to select & print just the current record?

Any suggestions appreciated.

Ian

Reply Like

24 May 2002, 10:44 AM

Crispin

Scooby Regular

Join Date: Jan 2001

Posts: 534

Likes: 0

Received 0 Likes on 0 Posts

Code:

Function PrintRecord()
    ' This procedure selects the current record and prints it.
    RunCommand acCmdSelectRecord
    DoCmd.PrintOut acSelection
End Function