[AccessD] Data Update

[B Heygood]

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