[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
>