automatically have the subform open on the a new record

[Aspen77]

I am using Access 2010 and I have a tabbed form. On one tab I have a subform in datasheet view. The user is having to scroll down hundreds of records to add or modify the last entry. Is it possible once the form opens to jump to the last record or a new record so they do not need to scroll down?

 

[TheAceMan1]

Aspen77 . . .

[blue]?[/blue]

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[TheAceMan1]

Aspen77 . . .

So were not fighting a naming problem, is the name of the subform [blue]sfrmDetailsDS[/blue]? If not did you substitute the proper name in:

[blue]Me.[purple][b]sfrmDetailsDS[/b][/purple].SetFocus[/blue]

Note: the methods used in this thread are methods of [blue]DoCmd[/blue]. The majority (if not all) of the methods [purple]require the object to have focus in order to work[/purple]. This is the reason for the set focus line in [blue]dhookom's[/blue] code. He is setting focus to the subform first!

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]