Form box pulling 2 data items

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ErnDog - 14 Jun 2007 22:06 GMT

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?

Reply to this Message

Wayne-I-M - 14 Jun 2007 22:23 GMT

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

Signature

# 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?

Reply to this Message

ErnDog - 14 Jun 2007 22:33 GMT

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

> Hi
>
[quoted text clipped - 15 lines]
> > 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?

Reply to this Message

Regan - 14 Jun 2007 22:48 GMT

>Wayne.. Does this get applied in the combo box properties/control source?
>
[quoted text clipped - 3 lines]
>> > 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?

Combobox-Properties-Data

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

Signature

Regan,
Paeroa
World famous in New Zealand

Reply to this Message