Form box pulling 2 data items

[ErnDog]

I have a table with 2 columns, product # and prod description. I have a form
build from a query linked to this table. I need to use a combo box to select
the prod # and have the prod description display as well. Can this be done?

 

[Wayne-I-M]

Hi

Try this

SELECT QueryName.ProductNumber, QueryName.ProductDescription FROM QueryName
ORDER BY [ProductNumber];

Column Count = 2

Column Widths = 1cm;4cm
(the column widths is just an idea by the way)

Change the query name and field names to what really are.

Hope this helps

 

[ErnDog]

Wayne.. Does this get applied in the combo box properties/control source?

Hi

Try this

SELECT QueryName.ProductNumber, QueryName.ProductDescription FROM QueryName
ORDER BY [ProductNumber];

Column Count = 2

Column Widths = 1cm;4cm
(the column widths is just an idea by the way)

Change the query name and field names to what really are.

Hope this helps
--

# and prod description
Wayne
Manchester, England.

I have a table with 2 columns, product # and prod description. I have a form
build from a query linked to this table. I need to use a combo box to select
the prod # and have the prod description display as well. Can this be done?