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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Inconsistent Add Record Performance 2
How to add record in Subform which is in another Subform 0
DLookup in Continuous form 0
Controlling a Sub Form 4
ACC2000 main form/multiple subforms...go to next record on subform 1
Merging from an Excel file with graphics 1
Populate main form from subform record 0
Please Help!!! Macro required to select new record in Subform 0

Top