Tab Control between subforms and forms and between Command Buttons and forms

[Ann Robey]

I have a navigation form that displays a form (Contacts) with three subforms (EventsAttended, LettersSent, and Notes) that are based on the one-to-many relationships between Contacts and the other three tables. The Contacts form has Command Buttons for Find, AddNew and Delete.
Problems:

1. When I click on the AddNew command button, the cursor remains on that button. I would prefer that it go to the first field (top of the tab order) in the Contacts form. How do I make that happen?
2. I would like the cursor to tab to the first field in the Contacts form after adding a record in any one of the subforms. This will enable a subsequent Find or Delete without having to manually reset the cursor. How do I do that?

I have worked quite a bit as a novice with Access but not with coding in Visual Basic or building macros so need some help if these functions require me to do either.
Thanks for any help you can provide.

[June7]

For no. 1: A click does not emulate the tab key action so the control clicked on retains focus. You can either manually tab from the button or use code in the button click event to set focus on another control. I use only VBA.
Me.controlname.SetFocus

For no. 2: I've never done this. Is the subform in Continuous or Datasheet view? Maybe in the subform AfterUpdate event, use the SetFocus method.
Forms!mainformname!controlname.SetFocus

[Ann Robey]

Each of the subforms is in continuous view.
Perhaps someone can help with macro language that would work?
Thanks.

[June7]

Google: Access macro SetFocus

Does this help http://support.microsoft.com/kb/209689?wa=wsignin1.0

[Ann Robey]

Thanks, that worked perfectly to redirect focus from a control button to the the field where I wanted it (problem #1).

However, when I tried the same thing to move from a subform to a specified field in the primary form I got the message that "there is no field "frmContacts Form" in the current record. It appears that the macro did not redirect focus from the subform to the primary form before attempting to put focus on the field I requested. What am I missing?

[June7]

I don't use macros, only VBA.

I would have to view the macro settings. Either post them (so much easier to post VBA code) or the database.