Drop Down List

[Brianfree]

Hi, i have a test form which has two fields in it.

Code and Product

There is a table called products with the following data..

1001, Car
1002, Bike,
1003, Plane

I want a drop down list so when i select a number the correct description appears in a text field next to it.

Please can you help!!!

 

[Remou]

It is possible to set up a combobox so that you can select the product and store the number. It is also possible to refer to the columns in a combo using the column propery, for example, you can set the control source of a textbox to:

=cboSomeCombo.Columns(1)

I suggest you look at the Northwind sample database that ships with every version of Access.

 

[Brianfree]

Hi, thanks for replying. How does this work if the fields is also attached to a table (has the field name against the control source)?

 

[Remou]

Which field is attached to the table? The textbox or the combobox?

If it is the textbox, I am not sure why you are not using a combobox by itself.

If a control has a control source, you must use code to change the value.