[drivingme crazy]

Hi all,
I'm working with an Access .mdb that consists of numerous SQL server
attached tables. I constructed a parameter query that selects the
data/fields that I'm interested in and in Access the query works fine.

Problem is, when I go to Word and try to select/use the query as the data
source for my mail merge doc, I can't see it on the browse list at all. To
further confuse my pea brain, when I remove the "parameter" criteria from
the query in Access and re-save it, Voila, I can see it on the Word side; but
which also makes it useless as a data source that selects a specific record
based on the criteria....

I've done this exact thing before, although not involving SQL server
attached databases, so I know that in principle, it works.....

Does anybody have any insight regarding this behavior??

TIA!!

Cal



p.s.- I'm using Word 2002 and Access 2002