[AccessD] When to Requery?

It should be a simple me.requery.  That forces a refetch of the info and if
it is sorted rev on the PKID that should go to the top. 


John W. Colby
Colby Consulting
www.ColbyConsulting.com 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Wednesday, December 05, 2007 10:47 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] When to Requery?

That's been the case all along and hasn't worked. A manual re-sort does it,
of course, but that's what I'm trying to avoid. The client wants all the
transactions sorted either TransactionID or TransactionDate DESC (which
amount to the same thing), but when a new row is added it goes to the bottom
until I manually re-sort and that's the step I need to automate.

Arthur

On 12/5/07, jwcolby <jwcolby at colbyconsulting.com> wrote:
>
> Sort on PKID in reverse chronological order in the subform's query?
>
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com