Go to new record after using Print Record command on form.

[Guest]

I am still a neophyte in designing forms for Access so perhaps there is a
simple answer to this question. I have a voucher form that is limited to
adding new records to a database. At the end of the form I added a Print
Record command by using the wizard from the Toolbox. After the voucher is
printed I want to have the form cleared and be ready for new input. Right now
it prints the voucher and stays in the current record. Any help would be
greatly appreciated.

 

[=?iso-8859-1?B?VmFsZW507W4gUGxheeE=?=]

ahearn,

the easiest way is add the following command before exiting the Click
bouton procedure:

DoCmd.RunCommand acCmdRecordsGoToNext

I assume you know how to enter to the VBA editor to modify the code.

Regards,

Valentín Playá
Madrid, Spain

 

[Guest]

This worked. Thanks for your help.