Bonnie Snider
BSNIDER at utah.gov
Wed Jul 23 11:33:32 CDT 2003
I know compared to you guys I'm a real novice. I've done a lot of databases and had to update a lot of fields, but I've always done it with update queries and macros. (I'm terrified of code and I don't understand what it means at all). But any time I've had to update a field based on an entry to a field in a record, I've always had to save the record before it would update. So in the properties of the field I would tell it to run a macro after update. The macro has a save record command and an open query command. The query is an update query. I know it's probably slower than code, but it works for me. >>> gustav at cactus.dk 7/23/2003 7:49:12 AM >>> Hi Virginia Well, if your form somehow is bound to table "DocumentList" and you use intMax = DMax(..., "DocumentList", ..) and this doesn't work, something else that prevents DocumentList from being updated must be going on. /gustav > I tried your suggestion and it didn't make any difference. _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com Bonnie Snider, LAN Administrator DWS North Admin Phone: 526-9253 Cell: 430-1219 FAX: 526-9744 EMAIL: bsnider at utah.gov