Display New Record First

J

Jedody69

New member

Local time

Today, 05:34

Joined

Sep 16, 2007

Messages

6

• Sep 20, 2007

• #1

I have a subform displaying as continous and sorted by date in descending order. My problem is that to add a new record, i have to scroll down to the bottom of the subform to get to the new record. Is there a way to have the new record at the top so that it is the first one showing?

Thanks

 

RuralGuy

AWF VIP

Local time

Today, 06:34

Joined

Jul 2, 2005

Messages

13,825

• Sep 20, 2007

• #2

Can you live with a Descending sort?

 

J

Jedody69

New member

Local time

Today, 05:34

Joined

Sep 16, 2007

Messages

6

• Sep 20, 2007

• #3

The sort is on a [transactiondate] field and it's descending because I want to view the most recent records first.

 

RuralGuy

AWF VIP

Local time

Today, 06:34

Joined

Jul 2, 2005

Messages

13,825

• Sep 20, 2007

• #4

I apologize. I didn't read the OP carefully enough. The only viable solution I've seen posted for this issue is to create another SubForm in DataEntry mode that only displays one record and carefully place it above your other SubForm.

 

J

Jedody69

New member

Local time

Today, 05:34

Joined

Sep 16, 2007

Messages

6

• Sep 20, 2007

• #5

Thanks RuralGuy. I've thought about that: having a button to ADD RECORD, then a pop-up subform where i input the details, then Save and have the fields filled in automatically, but unfortunately, I am not knowledgable enough YET to do that. Well, i guess that's my next topic to learn.

 

RuralGuy

AWF VIP

Local time

Today, 06:34

Joined

Jul 2, 2005

Messages

13,825

• Sep 20, 2007

• #6

If your new record will always have a [transactiondate] later than existing records then if you put in the date and Requery the SubForm, it will pop to the top.

 

neileg

AWF VIP

Local time

Today, 13:34

Joined

Dec 4, 2002

Messages

5,975

• Sep 21, 2007

• #7

Have a look at this thread
http://www.access-programmers.co.uk/forums/showthread.php?t=135655

 

J

Jedody69

New member

Local time

Today, 05:34

Joined

Sep 16, 2007

Messages

6

• Sep 21, 2007

• #8

Awesome Neileg!!! Thanks for pointing that thread out to me. I did do some searches before i posted mine, but obviously i didn't use the keywords that would have been required to pull up that thread.

Thanks again!