Problem with reference to control value in query

[KC-Mass]

I should clarify the I can iterate through the list box and get that part of
the query fine, I just can;t get the value from the combo box into the
query as a constant.

Again thanks



I have a form with a combobox and a list box. I have many selections in the
list box (company names) and one selection in the combo box, Parent company
ID.

I need a query to stuff the company name and the parent company ID into a
table.

Thanks for any help.

Kevin

[KC-Mass]

Re: Problem with reference to control value in query

Problem solved - thanks anyway
"KC-Mass" <connearneyATco mcastDOTnetwrot e in message
news:LaqdnYizUJ ZZ_ILVnZ2dnUVZ_ jednZ2d@comcast .com...

>I should clarify the I can iterate through the list box and get that part
>of the query fine, I just can;t get the value from the combo box into the
>query as a constant.
>
Again thanks
>
>
>
I have a form with a combobox and a list box. I have many selections in
the
list box (company names) and one selection in the combo box, Parent
company
ID.
>
I need a query to stuff the company name and the parent company ID into a
table.
>
Thanks for any help.
>
Kevin
>
>