expression builder - dilemma

[Guest]

I am producing a form which uses fields from record source "A" but also want
to refer to some data in record source QRY X.
I am trying to write an expression in the form which calls on data from the
query and using the the full expression [QRYX]![data] to refer to the data in
that qry but after hours of looking at online help and my access handbook, I
can not get it to work......Any help on this apparantly simple problem that I
am unable to work through would be much appreciated..

 

[aaron.kempf]

uh.. then join to the query?

you'd need to use views if you want to do this sort of thing


views rock


ADP Uber Alles

 

[Aaron Kempf]

you just need to add the query to the sql statement-- do a join from your
existing query into the new query

you can't just bind a sql statement to a query, you've got to use real SQL