Arthur Fuller
fuller.artful at gmail.com
Mon Dec 24 14:47:50 CST 2007
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