I am wondering if I can write a que 1

[hpl2001]

I am wondering if I can write a query that returns the contents of one field from a table, plus the value of one field on a form. I'm trying to make a union query for a combo box, where I want all the office names plus one new name that only exists in a field on the form.

Possible?

Thanks.

Holly

 

[randy700]

Have a look at this FAQ. Should be similar to what you want to do.
faq701-2330]

Randy

 

[hpl2001]

Thanks, that's helpful...Thanks!