John B.
john at winhaven.net
Tue Sep 16 12:00:15 CDT 2003
I've been reading up on this and ADH recommends not using ActiveForm. Maybe I'm overthinking this and missing something obvious but I'm definitely missing something :o) Can someone tell me how to save the record of the calling form when I can't pass the Me object to the function because it's being called from a shortcut menu? > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of John B. > Sent: Monday, September 15, 2003 5:41 PM > To: Access Developers discussion and problem solving > Subject: RE: [AccessD] Lose Focus > > > Charlotte: > That's what I'm experiencing. I have a function that is called by shortcut > menu from a number of different forms. The record needs to be saved before > it will work correctly. I could save the record automatically in the > after_update event but this would be saving the record after each > update for > something that rarely occurrs. > > The only time this is an issue is if someone adds a new row (this is a > continuos form) and then uses the shortcut function immediately. > Of course a > client just called and noted this. Click on another row first is the > immediate work around but not real obvious to them. > > I'm thinking I should be able to use ActiveForm to perform a > SaveRecord when > the shortcut menu calls the function. Any help on that idea would be > welcome. > > John B. > > > -----Original Message----- > > From: accessd-bounces at databaseadvisors.com > > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Charlotte > > Foust > > Sent: Monday, September 15, 2003 5:30 PM > > To: Access Developers discussion and problem solving > > Subject: RE: [AccessD] Lose Focus > > > > > > Sort of. The exit event of the form doesn't occur, so context menu > > won't automatically trigger a save of the current record. > > > > Charlotte Foust > > > > -----Original Message----- > > From: Drew Wutka [mailto:DWUTKA at marlow.com] > > Sent: Monday, September 15, 2003 2:12 PM > > To: 'Access Developers discussion and problem solving' > > Subject: RE: [AccessD] Lose Focus > > > > > > It should because the popup menu would have the focus. > > > > Drew > > > > -----Original Message----- > > From: John B. [mailto:john at winhaven.net] > > Sent: Monday, September 15, 2003 4:57 PM > > To: AccessD > > Subject: [AccessD] Lose Focus > > > > > > Does the Lose Focus event fire when then shortcut menu is popped up? > > > > John B. > > > > _______________________________________________ > > 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 > > _______________________________________________ > > 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 > >