[AccessD] The Command underlying the AZ and ZA buttons on the Access toolbar

Hi again, Arthur,

I should probably mention that my query sorts in descending order on the 
date of the payment.

The command button opens the subform filtered on the membership ID.  The 
underlying query makes sure the newest payment is at the top. 

The new event procedure on the subform's After Update event reruns the 
query, instantly putting the new record at the top.

I wasn't sure I'd mentioned the date sorting in the query.

Merry Christmas - my Larry is pouring drinks right now - gotta go.

Tina



Arthur Fuller wrote:
> My client is giving me so much aggravation on this! She wants the detail
> records to show up most recent first, meaning that after a detail row is
> added, it automatically drifts to the top of the subform, rather than
> remaining on the bottom. This is easy enough to do, just by clicking the ZA
> button on the toolbar after adding the new record, but what is the VBA
> command constant that represents this command?
>
> I guess I'll try building a macro and see what code gets generated. If
> anyone already knows how to code this, and has nothing better to do on
> Christmas Eve, let me know. I can't recall ever building a macro in Access,
> but what the hell, I'll give it a shot.
>
> Well, I gave it a shot, and I have no idea what this weird interface is
> about. Excel macros are soooo much easier! I need to relocate that list of
> Access command things and give that a try instead. The client is adamant
> that she wants the most recent transactions on top, and I can see her point,
> since there could be hundreds per master  record and they show the balance,
> which is the item of most immediate interest, and the transactions of
> immediate interest are those within the last few days to month, so that's
> why they should be on top not at the bottom.
>
> But I am having a most difficult time arranging this. Any advice greatfully
> appreciated.
>
> TIA.
> Arthur
>