Dataset view reversal, new record on top

  • Thread starter Thread starter Al Hotmail
  • Start date Start date
A

Al Hotmail

I have a subform that is in dataset view, it is sorted by date with the most
resent as the first row.
When I want to add a new record I have to go to the bottom of the dataset to
get to a blank record row.
I want to have the new record row at the top of the data set.
Can this be done?, HOW?
Thank I advance Al
 
I have a subform that is in dataset view, it is sorted by date with the most
resent as the first row.
When I want to add a new record I have to go to the bottom of the dataset to
get to a blank record row.
I want to have the new record row at the top of the data set.
Can this be done?, HOW?
Thank I advance Al
Click to expand...

You'll need to get tricky here. There's no way to put the new record at the
top in a datasheet or continuous form. What you'll need to do is use TWO
subforms - one, on top, with its Data Entry property set to Yes; Allow
Additions = Yes, set to one row high. Directly jammed under it put a second
subforms, Allow Edits = Yes, Allow Additions and Data Entry = No, to display
the existing records.
 
nice approach
how do I remove the header from the dataset on the bottom?
after I enter the last field data I want it to enter it into the bottom
table and clear the entry dataset and return to the first field?
Thanks again
al
 
nice approach
how do I remove the header from the dataset on the bottom?
after I enter the last field data I want it to enter it into the bottom
table and clear the entry dataset and return to the first field?
Click to expand...

Use a Continuous Form for both subforms (instead of a Datasheet); requery both
subforms in the AfterUpdate event of the data entry subform. You might need to
use

DoCmd.GoToRecord acForm, "Forms!mainform.Subformname.Form", acNewRecord

rather than requerying.
 
Back
Top