Requery as part of Got Focus

[Guest]

After moving my pointer in my underlying table with the Clone, I want to
requery a subform that is part of the same main form.

DoCmd.Requery & Chr$(34) & Me!Parent![Group Subform] & Chr$(34)

DoCmd.Requery "Query1"

Neither of the above works -- where am I going wrong, Mother darling?

 

[Dirk Goldgar]

After moving my pointer in my underlying table with the Clone, I want
to requery a subform that is part of the same main form.

DoCmd.Requery & Chr$(34) & Me!Parent![Group Subform] & Chr$(34)

DoCmd.Requery "Query1"

Neither of the above works -- where am I going wrong, Mother darling?

<g>

Please clarify your form structure for me. You are on one subform, and
you want to requery a "sibling" subform; that is, a different subform
that is on the same main form as the current subform? Is that right?

Maybe what you want is

Me.Parent![Group Subform].Requery

but it's hard to say for sure.

 

[Guest]

That is exactly what I was looking for --- whether it solves my actual
problem remains to be seen, but I was unsure of the actual format for the
command.

You da man!
--
Dave
Temping with Staffmark
in Rock Hill, SC

After moving my pointer in my underlying table with the Clone, I want
to requery a subform that is part of the same main form.

DoCmd.Requery & Chr$(34) & Me!Parent![Group Subform] & Chr$(34)

DoCmd.Requery "Query1"

Neither of the above works -- where am I going wrong, Mother darling?

<g>

Please clarify your form structure for me. You are on one subform, and
you want to requery a "sibling" subform; that is, a different subform
that is on the same main form as the current subform? Is that right?

Maybe what you want is

Me.Parent![Group Subform].Requery

but it's hard to say for sure.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

 

[Dirk Goldgar]

That is exactly what I was looking for --- whether it solves my actual
problem remains to be seen, but I was unsure of the actual format for
the command.

Maybe what you want is

Me.Parent![Group Subform].Requery

but it's hard to say for sure.

Note that, in the above example, "Group Subform" must be the name of the
subform *control* on the main form, which may or may not be the name of
the form object it displays.

 

[Guest]

And, in very deed, that does happen to be the actual name of the subform.
However the requery isn't doing what I thought it would -- namely effectively
filtering the display on the Group Subform to reflect the new selection.

My other question in this Discussion Group entitled "WHERE clause?" relates
to my attempts to filter the subform display.

Thanks for your help!
--
Dave
Temping with Staffmark
in Rock Hill, SC

That is exactly what I was looking for --- whether it solves my actual
problem remains to be seen, but I was unsure of the actual format for
the command.

Maybe what you want is

Me.Parent![Group Subform].Requery

but it's hard to say for sure.

Note that, in the above example, "Group Subform" must be the name of the
subform *control* on the main form, which may or may not be the name of
the form object it displays.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

 

[Dirk Goldgar]

And, in very deed, that does happen to be the actual name of the
subform. However the requery isn't doing what I thought it would --
namely effectively filtering the display on the Group Subform to
reflect the new selection.

My other question in this Discussion Group entitled "WHERE clause?"
relates to my attempts to filter the subform display.

I was already thinking you might be better served to take the approach
that Ken Snell has been working out with you in the discussion thread,
"Link Master/Child Fields?". So I'm going to consider this thread
closed, unless you have more to add to it. It's a bit confusing, as you
have several threads going that all seem relate to the same function in
your database.