Form box pulling 2 data items

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
Wayne.. Does this get applied in the combo box properties/control source?

Wayne-I-M said:
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.



ErnDog said:
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?
Click to expand...
Click to expand...
 
ErnDog said:
Wayne.. Does this get applied in the combo box properties/control source?
Hi
Click to expand...
[quoted text clipped - 15 lines]
Click to expand...

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
 
Back
Top