New record at top of continuous form detail

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

Guest

Is there a way to have the new record appear at the top of the detail section
on a continuous form instead of the bottom?
 
As much as I know you can't add records at the top of the detail section,
what we did is: we create a form, a single form, that includes all the fields
in the detail section, with a sub form that list all the records, continous
form, after we filled all the fields in the main form we saved the records
and refreshed the sub from, that sort Desc so the last record added apeared
on the top of the detail section.
So the user doesn't have to move to the last record on the buttom.
 
not that i know of, but you might try an unconventional layout to simulate
it. instead of a single continuous form, create two subforms in an unbound
main form. set the first subform's DataEntry property to Yes, to enter new
records only, and make the subform just "tall" enough to show one record.
set the second subform directly below the first subform, and set its'
AllowAdditions property to No.

so you can edit existing records in the second subform, but not add new
records; and add new records in the first subform, but not edit existing
records. to force newly added records to show up in the second subform, try
requerying the second subform in the first subform's Current event. i've
never used this setup, but in might work for you.

hth
 
Thanks. Where there's a will, there's a way, I guess. In this case, the way's
not worth the will, though. I was hoping for some form property I might have
missed somewhere...
 
Back
Top