Showing the add record field first in a sub form

[Kevin Dahlke]

I would like the blank default new record to be shown on the top of the sub
form query versus the end so i do not have to scroll through every record to
enter a new one in a continuous sub form. I was unsure if this is a query
function or a form function.

Thanks

Kevin

 

[KARL DEWEY]

You can have your subform call a macro On Open that has action of GoToRecord
- New.

 

[Kevin Dahlke]

Hi,

The sub form is always open and on a tab, so i placed it on the On got focus
event and we just click it, and it works.

Thanks