[AccessD] Data Type Mismatch in criteria expression

[Rocky Smolin]

I agree - requery is more certain.  But I've found that it also moves to the
first record.  So I usually have to save some kind of pointer to the current
record, do the requery, then use the pointer to redisplay the record that
was being worked.

r 

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

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
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com