How do I open a subform on a form and make it open on the new or blank record
at the top of the subform insted of it being at the bottom. I am opening the
form indata sheet view
Thanks
You can't. Datasheets add new records at the bottom, probably because
the developers used the paradigm of a lined pad of paper - if you're
adding new lines to a page, you add them at the bottom.
If you really need this appearance, you'll need two Subforms. I'd
recommend Continuous Forms rather than datasheets since it's too easy
for the user to change one datasheet (e.g. resizing columns) without
changing the other.
The two subforms would be, first, a one-line high continuous form with
its Data Entry property set to True; this would allow new records but
conceal all old ones. Lined up directly beneath it would be a second
subform with Allow Edits = True, Allow Additions = False to display
existing records. You'll need to Requery this second subform in the
AfterUpdate event of the first.
John W. Vinson[MVP]
