Scroll New Record to the bottom of a subform

[Paul H]

This is related to the same project I previously posted about. Everything functions well, but I would like a small cosmetic change. This all takes place in a subform. The On Load event triggers

    DoCmd.GoToRecord , , acNewRec

. This works fine, but it only shows a single blank record at the top of the subform with all the previous rows hidden above. I would prefer to have the new record appear at the bottom of the subform with the previous records that fit displaying above it. These two pics should make it clear.


Default View




Desired view.

This is a minor matter. If there is simple solution. I'll take it. If not, I'll let it slide.

[ranman256]

That is the default way,for them to be on top.
just click the new record button (asterisk icon) at the bottom record counter/tool.

[Bulzie]

Kind of wonky but maybe manually add some rows (create an Add Record button but add these extra Goto):

DoCmd.GoToRecord , "", acNewRec
DoCmd.GoToRecord , "", acPrevious
DoCmd.GoToRecord , "", acPrevious
DoCmd.GoToRecord , "", acPrevious
DoCmd.GoToRecord , "", acPrevious
DoCmd.GoToRecord , "", acNewRec
Me.YourFirstFieldInRow.SetFocus

Another idea is to include unbound fields in the footer with an Add button and when they put in the new record values, use button to write them to table, then Requery the form and blank out those unbound fields.

[Paul H]

Gonna leave it just the way it is. The changes were just cosmetic. The form finally functions as intended and is out for testing right now. I'll only make changes as required by my testers.

Thanks for your suggestions.

Paul