adding new record in subform

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
 
V

Van T. Dinh

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.
 
Top