[AccessD] Data Type Mismatch in criteria expression

[Bill Benson]

I prefer requery over refresh. You can look up the difference and decide
whether there is any risk in choosing the lighter weight refresh.

In the situation described it does seem like no characteristics of the data
are being modified which would necessarily ineligiblize the record(s) being
shown... but they could.
On Dec 30, 2015 9:36 AM, "Rocky Smolin" <rockysmolin at bchacc.com> wrote:

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