Showing the add record field first in a sub form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kevin Dahlke - 29 May 2008 16:30 GMT

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

Reply to this Message

KARL DEWEY - 29 May 2008 19:35 GMT

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

Signature

KARL DEWEY
Build a little - Test a little

> 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
[quoted text clipped - 4 lines]
>
> Kevin

Reply to this Message

Kevin Dahlke - 29 May 2008 22:58 GMT

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

> You can have your subform call a macro On Open that has action of GoToRecord
> - New.
[quoted text clipped - 7 lines]
> >
> > Kevin

Reply to this Message