[AccessD] Data Update

[Heenan, Lambert]

The GotFocus event does not trigger in that situation. It's no good for your needs.

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of B Heygood
Sent: Wednesday, December 30, 2015 11:13 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Data Update

Interesting. 
I can't get the suggestion below to work EVEN when first opening the form....

Lost focus not so much..


-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Wednesday, December 30, 2015 6:36 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Data Type Mismatch in criteria expression

I think the GotFocus event of the original form will trigger when you close the update form.  You can test by putting MsgBox "!" in the GotFocus event of the first form, open the second form, close it and you should see !. If you do then you can put me.refresh in that event.

HTH

Rocky
 

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bob Heygood
Sent: Wednesday, December 30, 2015 6:15 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Data Type Mismatch in criteria expression

I need to open another form via a button and make some changes to various data. After closing that form, I need to see the newly updated data on the original form.
My question is what form event should I use (on current or....) and what method (.requery or .re.....) to be sure I see the data updated?

Tia

Bob


--
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