Re: Qry not pulling bound column problem


"AJ" <AJ@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E5B86479-DA0A-40B2-B6AB-897CE33B74A2@xxxxxxxxxxxxxxxx
I need the Union Qry... or so I think I do because... to use Jeanette's
example I am pulling...

select Tablex.fieldA,tablex.fieldB from Tablex
union
select tabley.fieldA,tableY.fieldB from TableY

to get 2 fields.

What are TableX and TableY? How (if at all) are they related? What do they
have to do with the rowsource of a combo box? What is the query mentioned in
your original post?

The UNION query will show ALL records in TableX and ALL records in TableY,
with no relationship between them; if FieldA is the ID and FieldB is the
description text, I don't see how this query is relevant to your original
post (which I understood to be about a Combo Box in a query data***).


.