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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculation 5
How to generate sequentially numbered vouchers ? 1
Revised Calculation 11
Access Automatically Send a notification email once a record is added 0
Select Record in query, save as New Record then edit New Record 1
New Record 4
Records position in hardcopy form 7
Button on form to print report for current record 4

Back
Top