New record at top of subform

  • Thread starter Thread starter Dean H
  • Start date Start date
D

Dean H

I have a question about sub forms. When displaying my
main form the sub form displays 3 records at once. My
question is, when I make a new record how can I get the
new record to display at the top of the sub form rather
than the bottom? I am using Access 97. Any help would be
appreciated!
 
-----Original Message-----
I have a question about sub forms. When displaying my
main form the sub form displays 3 records at once. My
question is, when I make a new record how can I get the
new record to display at the top of the sub form rather
than the bottom? I am using Access 97. Any help would be
appreciated!
.
Does the subform record source has a field that can be
Click to expand...
sorted to get the records in the order you want such as an
auto number field? If so you could try sorting that field
in decending order.
 
-----Original Message-----

sorted to get the records in the order you want such as an
auto number field? If so you could try sorting that field
in decending order.
.
Click to expand...
I do have an autonumber field, but even if I sort by "Z
to A" when I click the new record button I always get the
new record at the bottom of the sub form. Is there some
way to force the new record to appear at the top of the
form?
 
Dean H said:
I do have an autonumber field, but even if I sort by "Z
to A" when I click the new record button I always get the
new record at the bottom of the sub form. Is there some
way to force the new record to appear at the top of the
form?
Click to expand...

No.
 
No, but you can simulate the effect you want by having two subforms. One
one line one at the top, with its Data Entry property set to Yes, so it only
shows a new record, and one larger one immediately below it showing the
existing records. Set the child link of both subforms to the same master
link on the main form.


--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 
Back
Top