Subform data entry?

[NewShoes]

Hey all,

Is there any way I can make a subform put a new blank record at the top rather than the bottom? Problem is, we are getting a lot of records now and scrolling to the bottom in input a new record is getting annoying!

Also, I have a menu that always stays on top of any other Access screen, is there anyway to change so this goes behind any new form/query result.

I'm using Access 2007.

Many thanks for any help,

NS

 

[pbaldy]

In a word, no. The two workarounds I've seen are either 2 subforms, one with Data Entry set to Yes above another, or unbound textboxes used for data entry placed above the actual subform. Either can be made to look pretty seamless to the user.

It sounds like the menu has popup and/or modal set to yes.

 

[NewShoes]

Thanks for your quick reply.

Just a thought, but could I set the focus to the new "input" fields?

Thanks,

-NS

 

[pbaldy]

Sure; this type of thing, probably in the load event:

DoCmd.GoToRecord , , acNewRec