how to show latest record on subform above new record position

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone know, (when dealing with a long list of items on a subform), how
to position the 'view' so that the new record, and last few entries remain in
the view. After adding a new row the view goes to the top of the list and I
have to scroll to the end to add another record.
thank you.
 
NJS

This wouldn't normally happen. It sounds like you have some code to
Requery the subform, perhaps on its AfterUpdate event or some such. I
guess the first step it to check and see why this is there, and whether
it is really necessary.

Another idea that is sometimes used is to have a second subform, or an
equivalent set of unbound controls, which are judiciously placed above
the subform, and these are used for the entry of new records. In the
case of the unbound controls, you would run an Appand Query to put the
new record into the tables and hence to the existing subform. In this
case you would probably have the subform records sorted with the most
recently entered at the top.
 
Back
Top