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

Gow to get started on another field after Add New Record

P: n/a
I changed my form and added another field on it. I want that this field
(combo) is the first approached when I do a Add New Record button. how
to get it started with that field. Tab Order modification doessn't
change it.
This is the VB code of Add New Rec:

Private Sub Add_New_Record_Click()
Me.AllowAdditions = True

On Error GoTo Err_Add_New_Record_Click
DoCmd.GoToRecord , , acNewRec

Exit_Add_New_Record_Click:
Exit Sub

Err_Add_New_Record_Click:
MsgBox Err.Description
Resume Exit_Add_New_Record_Click

End Sub

Jan 17 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Hi,

The way I have done this in the past is to open my form in design view, click
on View from the top menu bar, then select Tab Order. From here, simpy drag
each field into the order that you want them to be selected in.

HTH

Tazzy

AA Arens wrote:
>I changed my form and added another field on it. I want that this field
(combo) is the first approached when I do a Add New Record button. how
to get it started with that field. Tab Order modification doessn't
change it.

This is the VB code of Add New Rec:

Private Sub Add_New_Record_Click()
Me.AllowAdditions = True

On Error GoTo Err_Add_New_Record_Click
DoCmd.GoToRecord , , acNewRec

Exit_Add_New_Record_Click:
Exit Sub

Err_Add_New_Record_Click:
MsgBox Err.Description
Resume Exit_Add_New_Record_Click

End Sub
--
Message posted via http://www.accessmonster.com

Jan 17 '07 #2

P: n/a
On 17 Jan 2007 03:19:26 -0800, "AA Arens" <ba***********@gmail.com>
wrote:

Check out SetFocus in the help file.
-Tom.

>I changed my form and added another field on it. I want that this field
(combo) is the first approached when I do a Add New Record button. how
to get it started with that field. Tab Order modification doessn't
change it.
This is the VB code of Add New Rec:

Private Sub Add_New_Record_Click()
Me.AllowAdditions = True

On Error GoTo Err_Add_New_Record_Click
DoCmd.GoToRecord , , acNewRec

Exit_Add_New_Record_Click:
Exit Sub

Err_Add_New_Record_Click:
MsgBox Err.Description
Resume Exit_Add_New_Record_Click

End Sub
Jan 17 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.