Concatenate

[vw]

I have a table which has 1 column that sepcifies in each
of the 6 rows either "House" and "Cottage", the column
next to it contains 3 different numeric codes for
each "House" and "Cottage".

I have a combination of a List Box, a Macro, and a Query
(A) which allows me to select the "House" category and
provides me with the 3 codes.

I then have a 2nd Query (B), in which I need all three
codes to auto-populate the "Cirteria" in design view.

I have tried to link the criteria field in Query B to the
numericode field in Query A, but it returns an error when
I execute.

Can Anyone help?
..