[AccessD] Data Type Mismatch in criteria expression

Rocky Smolin rockysmolin at bchacc.com
Wed Dec 30 08:35:31 CST 2015


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



More information about the AccessD mailing list