Allow Additions Sort Order

[Arturo]

I have a subform set to Allow Additions. If a new record is added, it is
assigned a number via the Autonumber feature after the record is appended to
the main table. When these records are appended back to my working table. all
the current records sort OK. The Allow Additions new record is always at the
bottom. Here is my dilemna.

When a new record is added to the blank field, the Users have the option to
view a report from that screen. After viewing the report and returning to
that screen. the new record is now at the top. Behind the subform there are
two things that can happen. I can sort by record number or by date. Either
way, when the form reopens, that puts the new record at the top.

Is there a way to hold this record at the top or the bottom of the screen?

 

[Jeff Boyce]

Arturo

"top" and "bottom" are relative to how you sort. Are you saying that you
want all the "old" records in one sort order, but the new record in another
sort order?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Arturo]

I think that was what I was saying. I believe I figured a way to do it. I can
add a field with a number larger than say 10,000. (There will never be that
many records.) If a new record is created, assign that number to that record,
update the large number by 1, and repeat the process, if they add more than
one record, which may never happen. Therefore, my two sort methods will work
perfectly. After the record is appended to the main table, I can reset the
large number back to 10,000 or whatever.

Thanks for your help. If there is another way, i"m listening.

 

[Jeff Boyce]

Arturo

I've not run across a way to do this before, but it sounds like you've found
a solution...

Regards

Jeff Boyce
Microsoft Office/Access MVP