[AccessD] Order By question

Charlotte Foust cfoust at infostatsystems.com
Mon Dec 17 16:28:08 CST 2007


It goes with using a DESC sort.  Access add rows are always at the
bottom.  I think you'd have the same problem with a query.

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 2:22 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Order By question

Thanks. I'll give that a shot. Typically, the way the app is used, they
only add a single transaction to the subform on each visit to the parent
form.
(The parent form displays Riders and the subform displays Riding
Lessons, payments, tack purchases and such.) The subform draws directly
from the Transactions table. Would I be better off changing its record
source to a query?

Arthur

On 12/17/07, Charlotte Foust <cfoust at infostatsystems.com> wrote:
>
> 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
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list