[AccessD] Data Update

[Rocky Smolin]

Happy to help.  I was playing some music in North Park today.  When I came
out the street was totally flooded.  Crazy.

r 

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bob
Heygood
Sent: Tuesday, January 05, 2016 8:42 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Data Update

Hey Rocky,
Just now getting over the holidays and such.
Wanted to thank you for your response and offer. I ended up making the
"calling" form bound and solved most of my problems. Still some issues where
the info is not current, but I have used some smoke and mirrors to make sure
the user winds up with the "right" data.
When I get the time I sure would like to document all the info everyone has
contributed as it relates to one form calling another and updating the data.
This seems like a common task

Thanks,

Bob
BTW - maybe for once we can brag/complain about our weather. 3" here inland
today.



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

Bob:

If you don't get it worked out this morning let's do a Skype and get 'er
done.  I'll be out most of the morning but here after 1pm.  Or you can come
by.  Bit of a drive but lot worse places to visit than Del Mar.

Let me know.

r


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

Interesting. 
I can't get the suggestion below to work EVEN when first opening the
form....

Lost focus not so much..


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

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