New Record

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

Guest

Hi,

I am going from Page 3 on a tab control back to the main form by using:

Forms![frmEmployee].[strEmployeeNumber].SetFocus

This works fine but I want it to be a new record and not the current record.
How can I do that? Thanks for the help...
 
After setting the focus to the field in the main form, run the code to start
a new record

DoCmd.GoToRecord , , acNewRec
 
Thanks, it did exactly what I wanted.

Ofer Cohen said:
After setting the focus to the field in the main form, run the code to start
a new record

DoCmd.GoToRecord , , acNewRec

--
Good Luck
BS"D


Ann said:
Hi,

I am going from Page 3 on a tab control back to the main form by using:

Forms![frmEmployee].[strEmployeeNumber].SetFocus

This works fine but I want it to be a new record and not the current record.
How can I do that? Thanks for the help...
Click to expand...
Click to expand...
 

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

Moving from subform back to mainform 2
Option Box to change record source 3
SetFocus 8
Empty Records 5
Need combo box to refresh when moving to new record 2017 1
open nested subform to new blank record 1
Backtabbing between SubForms on TabControls 2
how do I add a do until loop to this code? 2

Back
Top