marian68
asked on
new record button in a form
I have a form with 3 pages.
I would like to know if it is possible, after I finished entering a new record(so I am on the page 3) when I push on the button "new record" to go automatically to the beginning of the 1st page to start entering another record?
Thank you very much,
I would like to know if it is possible, after I finished entering a new record(so I am on the page 3) when I push on the button "new record" to go automatically to the beginning of the 1st page to start entering another record?
Thank you very much,
Last Comment
if you are using tabcontrol, use this
me.tabcontrol.pages(0).set
docmd.gotorecord,,acnewrec
me.tabcontrol.pages(0).set
docmd.gotorecord,,acnewrec
ASKER
I was talking about the default button of Access to create a new record.
Do you recommend me to create a button and to use the above code?
Thank you very much
Do you recommend me to create a button and to use the above code?
Thank you very much
do you mean the button with >* ?
i think you better create your button for this purpose
i think you better create your button for this purpose
ASKER
Yes the button you mentioned >*,
Ok, I will create my own button for this purpose and I will tell if it works in a couple of minutes.
Thank you very much
Ok, I will create my own button for this purpose and I will tell if it works in a couple of minutes.
Thank you very much
ASKER
I built a command button on the last page of the form.
When I am using the first code the form is ready for a new record but I remain on the same page.
When I am using the 2nd code it shows me the it is something wrong with "tabcontrol" from your code, it is blackened. Do I have modify the "tabcontrol" with something?
Here are the code
Private Sub Command667_Click()
Me.TabControl.Pages(1).Set
DoCmd.GoToRecord , , acNewRec
End Sub
Thank you
When I am using the first code the form is ready for a new record but I remain on the same page.
When I am using the 2nd code it shows me the it is something wrong with "tabcontrol" from your code, it is blackened. Do I have modify the "tabcontrol" with something?
Here are the code
Private Sub Command667_Click()
Me.TabControl.Pages(1).Set
DoCmd.GoToRecord , , acNewRec
End Sub
Thank you
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
It worked by instead of this chunk of code
"tabcontrol.pages(0)"
I put the name of the first page of the form
Thank you
"tabcontrol.pages(0)"
I put the name of the first page of the form
Thank you
Microsoft Access
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.
226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
docmd.gotorecord,,acnewrec
docmd.gotopage 1