New record at top of subform

[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!

 

[Alan Fisher]

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

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.

 

[Dean H]

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

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?

 

[Rick Brandt]

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?

No.

 

[Adrian Jansen]

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