[AccessD] Data Type Mismatch in criteria expression

[Heenan, Lambert]

Bob,

If you open the second form in dialog mode...

DoCmd.OpenForm "YourFormName", , , , , acDialog

... then the calling form waits until either the second form closes or is set to Invisible.

Consequently you don't need any specific event, just call Me.Refresh in the next line of code after opening the form. (Or Me.Requery if new data was ADDED).

Lambert

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bob Heygood
Sent: Wednesday, December 30, 2015 9: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