adding new record in subform

  • Thread starter Thread starter steve
  • Start date Start date
S

steve

hello

If I ad a new record with
DoCmd.GoToRecord , , acNewRec
it goes to the end off the form, is it possible to add a
new row/record between two records in a subform.


thanks
steve
 
Sorry, no. However, if you set the sorting in the RecordSource Query, you
can do a Requery to get the Records sorted correctly after addition.

Alternatively, you can use the OrderBy Property of the Form being used as
the Subform.
 
Back
Top