Current Record?

[hi there]

hi all,

i know i should probably know this but my mind is blanking. i have an entry form with a print command button on it. what i would like to do is have the user click the button and access print the current record displayed. currently, when the user clicks the button it prints all of the records from the record source. can someone help me with this. just a little background i have an event procedure attached to the On Open event on the form that creates a blank (new record) form when the object is opened. basically, what i need is for the user to print the blank form and then they're going to fill out the form (hard copy) with a pen and then enter this information to populate the dbase later. many thanks to everyone for any help with this.

 

[Jack Cowley]

Hmmm. Seems a bit of a long way round to me, but it is our database. Create a report with the layout you want (make it look like your form). Print this report when the button is click. Now you will get your blank 'form' for the user to fill out before filling in the form.

Why not print up a bunch of forms, pass them out and then let the user go directly to the form for data input? Just a thought...

hth,
Jack

 

[KevinM]

Search the reports forum.

This question has been asked at LEAST once everyday this week!

Moderator...How about a 'STICKY' on how to do this.

Would save a lot of people a lot of time !

 

[pono1]

Hi There,

Create a command button using the wizard, selecting "Record Operations" under Categories and "Print Record" under Actions.

Regards,
Tim

 

[Rich]

Kevin, who would decide which is the better method ?