[AccessD] Order By question

To get it to the top, you have to requery the subform, not the parent.
Do you really want to do that each time a new record is added?

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Monday, December 17, 2007 1:38 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Order By question

I have a form with a subform that is ordered either by TransactionID
DESC.
It seems, however, that I cannot control the ordering. The Transactions
part is the subform. There's a button to edit a transaction and another
button to create a new one. The new transaction does not automatically
go to the top row of the subform. Instead, the user has to click the
TransactionDate column and then press the ZA button on the toolbar. I
cannot seem to make this happen automatically. If I just requery the
parent form, will that do it? Or any other ideas?

TIA,
Arthur
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com