How Me works?

Matt,

From FormOne to FormTwo Requery...

Forms![FromTwo].Requery

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"mbr96 via AccessMonster.com" u8822@uwe wrote in message
news:a2e77b9b2cfc6@uwe...
Setting aside the focus part (a good topic too), I think we're all in
agreement that "Me" refers to the object from which you are running code.
That seems to be the essence of my problem - I have a Me.Requery in the
second form, intending to requery the data source from the first form.

In your example, what syntax do you use to tell FormOne to requery FormTwo?
Matt

Gina Whipp wrote:
Rick,

My understanding is different... Okay, I have two forms open FormOne and
FormTwo. The Me.Requery is on FormOne but presently FormTwo has the focus.
Unless I tell FormOne to Requery FormTwo, running Me.Requery on FormOne
does
nothing for FormTwo. Boy, say that ten times fast! That is what I always
understood, at least that is the way it always appeared to me.

Gina Whipp wrote:

mbr96,

[quoted text clipped - 4 lines]
get the Requery you have to *name* them in your statement. Does that
help
you understand?

I don't think that is correct. Some of the RunCommand commands act upon
the
object that has focus regardless of where the code is running, but
Me.Requery or Me.(AnythingElse) will always act upon the object running the
code. Focus does not matter.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/201001/1

Matt,

We'll be waiting if you get stuck!

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"mbr96 via AccessMonster.com" u8822@uwe wrote in message
news:a2e7af7a0c290@uwe...
Thanks again to both of you, I got this working with a full form reference
from one form to requery the subform control on the other form. I was
thinking that once I had changed the recordsource of an object, that object
was now "Me", but noooooo. Now for some experimentation with focus...

Matt

mbr96 wrote:
Setting aside the focus part (a good topic too), I think we're all in
agreement that "Me" refers to the object from which you are running code.
That seems to be the essence of my problem - I have a Me.Requery in the
second form, intending to requery the data source from the first form.

In your example, what syntax do you use to tell FormOne to requery FormTwo?
Matt

Rick,

[quoted text clipped - 16 lines]
Me.Requery or Me.(AnythingElse) will always act upon the object running
the
code. Focus does not matter.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/201001/1

Gina Whipp wrote:

Rick,

My understanding is different... Okay, I have two forms open FormOne and
FormTwo. The Me.Requery is on FormOne but presently FormTwo has the
focus. Unless I tell FormOne to Requery FormTwo, running Me.Requery on
FormOne does
nothing for FormTwo. Boy, say that ten times fast! That is what I always
understood, at least that is the way it always appeared to me.

That is what I said. "Me" operates on the form where the code is run
without regard to focus. Your original reply seemed to indicate that the
form needed to have focus.

"whichever object has the focus AND if the Me.Requery is in that object then
that is what will get the Requery."

Your statement is correct if you remove the focus part from it.

Rick,

Hmmm, okay I can see how I poorly phrased that!

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Rick Brandt" wrote in message
...
Gina Whipp wrote:

Rick,

My understanding is different... Okay, I have two forms open FormOne and
FormTwo. The Me.Requery is on FormOne but presently FormTwo has the
focus. Unless I tell FormOne to Requery FormTwo, running Me.Requery on
FormOne does
nothing for FormTwo. Boy, say that ten times fast! That is what I always
understood, at least that is the way it always appeared to me.

That is what I said. "Me" operates on the form where the code is run
without regard to focus. Your original reply seemed to indicate that the
form needed to have focus.

"whichever object has the focus AND if the Me.Requery is in that object then
that is what will get the Requery."

Your statement is correct if you remove the focus part from it.