change order of new record in subform

[jmoore]

I have a subform (continuous forms view) that is based on a query, sorted in
descending order on date field. Is it possible to have the New Record
display at the top of the form, rather than having to scroll to the bottom of
the page to enter new information?

 

[Danny J. Lesandrini]

I'm not aware that this is possible in Access, but I've gotten around it on occassion.
But to do so, you have to abandon the Access built-in Add record paradigm.

It takes some programming in VBA, so you have to be comfortable with that. What
you'll need to do is to create an "Add New" set of text boxes in the form header, above
the detail section. These will be unbound controls and you'll need a Save button.

The user then may enter text in the unbound text boxes and must click the Save button.
Behind the scenes, your code will perform an INSERT on the table and requery the form.

If you need help with this idea, post back.

 

[jmoore]

Danny, thanks for the quick response. I also had another problem surface
that I just posted. I may have to fix that one before I can move on with
this. I am familiar with programming in VBA, however, very shaky at it. It
has been a very long time since I've needed to use Access at work. Any help
you can give is much appreciated. The subform has 2 combo boxes and 3 text
boxes. Do you need more information? Thanks.