Subform query

[PeterM]

I'm running Access 2003.

I have a form called FormA. Withing FormA is a subform SubFormB. SubFormB
is a continuous form. SubformB has record selectors turned on. I wrote a
query for SubFormB that uses a membername field on SubFormB as the key for
the following query.

Select * from tableX where
tableX.person_name = forms!FormA!SubFormB!membername

The query above is not working...it's prompting me for a variable called
"forms!FormA!SubFormB!membername"....

Any help would be appreciated!

 

[KARL DEWEY]

If I read you correctly you wrote a query used as record source for SubFormB
that uses a field from SubFormB for criteria.

Until the query runs there is no data in SubFormB for the query criteria.