Form box pulling 2 data items

[Guest]

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?

 

[Guest]

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

 

[Guest]

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?

 

[Regan via AccessMonster.com]

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

Hi

[quoted text clipped - 15 lines]

Combobox-Properties-Data

Row source type = table\Query
Row source = Query Wayne I M gave you

--
Regan,
Paeroa
World famous in New Zealand

Message posted via AccessMonster.com