combobox

J

Jessica

Hello


I have a form made that inputs data to table 2. I am trying to make a combo
box that contains data from two fields in table 1. I tried using this as the
control source =[tblProducts]![strBrand] & "" & [tblProducts]![strFlavor]
but the results are #Name?. Is this possible to do?

Thank you,
Jess
 
J

John Vinson

Hello


I have a form made that inputs data to table 2. I am trying to make a combo
box that contains data from two fields in table 1. I tried using this as the
control source =[tblProducts]![strBrand] & "" & [tblProducts]![strFlavor]
but the results are #Name?. Is this possible to do?

Thank you,
Jess
Click to expand...

What value are you trying to insert into Table2? What are the relevant
fields in tblProducts?

I think you'll want to base the Combo on a query such as

SELECT tblProducts.ProductID, tblProducts.strBrand & " " &
tblProducts.strFlavor
FROM tblProducts
ORDER BY strBrand, strFlavor;

Set the Combo's Column Widths property to 0;1.5 to conceal the ID.

John W. Vinson[MVP]
 
J

Jessica

Thanks John that worked Great.

Jess


John Vinson said:
Hello


I have a form made that inputs data to table 2. I am trying to make a
combo
box that contains data from two fields in table 1. I tried using this as
the
control source =[tblProducts]![strBrand] & "" & [tblProducts]![strFlavor]
but the results are #Name?. Is this possible to do?

Thank you,
Jess
Click to expand...

What value are you trying to insert into Table2? What are the relevant
fields in tblProducts?

I think you'll want to base the Combo on a query such as

SELECT tblProducts.ProductID, tblProducts.strBrand & " " &
tblProducts.strFlavor
FROM tblProducts
ORDER BY strBrand, strFlavor;

Set the Combo's Column Widths property to 0;1.5 to conceal the ID.

John W. Vinson[MVP]
Click to expand...
 
Top