Problems focusing on a subform field

[A Jedi]

I am using access 97 on a windows 98 machine

I created a 2 page entry form using tabs. The first page works fine. When you click on the tab for page two you have focus issues.

The page comes up properly and the focus is put on the first field. Good so far ...
the entry page is longer than the screen. As you shift from entry field to entry field the focus does not change. Once you go below the bottom of the screen you can't see anything. This forces the user to manually adjust the scroll bar as the continue to enter data. Irritating to say the least!!

It seems as if the focus is being placed on the subform rather than the entry field. Any suggestions??

 

[smozgur]

Hi A Jedi,

I think we can tell it to add new record when we want it to be focused in New Record row. It should scroll to new record automaticially.

Say your subform name is mysubform;

    With Me.mysubform
        .SetFocus
        .Form.Recordset.AddNew
    End With

I hope it helps.
Suat