David Emerson
newsgrps at dalyn.co.nz
Mon Dec 24 14:56:59 CST 2007
Arthur, Would it work to have the record source of the subform sorted in descending order, then run a refresh after a new record is added? David At 25/12/2007, you 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 >-- >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com