[AccessD] Data Update

[Heenan, Lambert]

GotFocus is a total red herring, IMHO :-)


" The code in the calling form will stop when you open the called form and pick up right after the called form closes."  - BUT ONLY IF YOU OPEN THE SECOND FORM IN DIALOG MODE!!!


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

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

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com