[AccessD] Data Update

Rocky Smolin rockysmolin at bchacc.com
Wed Dec 30 10:18:47 CST 2015


And if the called form is modal then you don't have to use got focus.  The
code in the calling form will stop when you open the called form and pick up
right after the called form closes.  So you should be able to put your
DLookup right after the .OpenForm statement.

r 

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Rocky Smolin
Sent: Wednesday, December 30, 2015 8:15 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Data Update

well requery won't work if the form is not bound.  So you'll have to go
directly to the field in the table where the called form stored the data and
refresh your text boxes on the calling form - probably simplest then to use
DLookup for that.

r 

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of B
Heygood
Sent: Wednesday, December 30, 2015 8:03 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Data Update

Nor is this:

Private Sub Form_GotFocus()
    Me.Requery
End Sub


-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of B
Heygood
Sent: Wednesday, December 30, 2015 7:43 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Data Update

This is not working:

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

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



More information about the AccessD mailing list