By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,628 Members | 1,880 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,628 IT Pros & Developers. It's quick & easy.

A97: How go to new record on data entry form

P: n/a
MLH
Access 97 help says the following...
Add new data in Datasheet or Form view

1 Open a Datasheet, or form in Form view.
2 Click New Record on the toolbar.
3 Type the data you want, and then press TAB to go to the next
field.
4 At the end of the record, press TAB to go to the next record.

I want to accomplish the same objective from within code. How do
I do that?
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
MLH wrote:
Access 97 help says the following...
Add new data in Datasheet or Form view

1 Open a Datasheet, or form in Form view.
2 Click New Record on the toolbar.
3 Type the data you want, and then press TAB to go to the next
field.
4 At the end of the record, press TAB to go to the next record.

I want to accomplish the same objective from within code. How do
I do that?


The easiest method I know of is so open the form's property sheet, click
on the Other tab, and set Cycle to AllRecords.

A command you might want to look at if that does not suit your needs is
DoCmd.GoToRecord , , acNewRec
Nov 13 '05 #2

P: n/a
MLH
acNewRec did it! Many thx!
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

On Thu, 02 Jun 2005 14:15:28 GMT, Salad <oi*@vinegar.com> wrote:
A command you might want to look at if that does not suit your needs is
DoCmd.GoToRecord , , acNewRec


Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.