Add records to the TOP of a continuous form... 2

[sjdk]

I have a continuous form that has attendance transactions on it. By the end of a school year, it can get quite lengthy. The form displays about 12 lines of entries on the screen. My users want to be able to add the new records to the top of the list, rather than the bottom. Is there a way to make the 'add new' line appear at the top? Or, is there a way to have the form open and show the bottom 12 records with the 'add new' at the bottom? The users don't want to have to scroll to the bottom to enter a record, but they also want to be able to see the most recent entries when they open the form. I hope I am making sense! I have checked with other programmers here at work, and no one had any suggestions. Any suggestions would be GREATLY appreciated!!

 

[jfgambit]

Is there an AutoNumber for the entries? Have you tried sorting the information in descending order?

"I know what you're t'inkin', ma petite. Dat Gambit... still de suave one, no?"

 

[sjdk]

They are in the correct order, I just want to be able to change the way it looks on the screen. Thanks anyways!!

 

[verplexd]

So you are saying that it looks something like this...

AUTONUMBER    NAME          PHONE         EMAIL     
5             Jim           555-1234      jim@no.com
4             Bill          555-1334      bill@no.com
3             Sue           555-1434      sue@no.com
2             Lisa          555-2344      lisa@no.com
1             Ralph         555-1344      ralph@no.com

*

* = New entry

And you want it to look something like this?

AUTONUMBER    NAME          PHONE         EMAIL

*

5             Jim           555-1234      jim@no.com
4             Bill          555-1334      bill@no.com
3             Sue           555-1434      sue@no.com
2             Lisa          555-2344      lisa@no.com
1             Ralph         555-1344      ralph@no.com

* = New entry

 

[scriverb]

See thread: thread181-539772

This thread deals with having the last added record on the top of the continuous form. You could modify this slightly to have the top 12 sorted to the top. As for the New Record I don't think that is possible but you could design your main form so that right across the top of the subform is where you add a new record in UnBound controls that match exactly the columns of the subform. Then with the click of a Save button next to the controls use VBA code to take these values and perform a recordset .addNew and update the subform table with the new record. The a subsequent resort would put a new group of 12 at the top.

I hope that this helps you. Or confuses you. Let me know if I can help further with this.

Bob Scriver

 

[sjdk]

Finally, I am getting back to this project....

THANK YOU, Bob!! Your suggestion worked like a charm! I appreciate the help!

Steph

 

[scriverb]

Steph. I am please that that thread helped you. Thanks for the star.

Bob Scriver

Nobody believes the official spokesman... but everybody trusts an unidentified source.
Author, Bagdad Bob???