Drop down menus

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

Guest

Hi I work for a small manufacturing Company and we have Raw Materials that we
use to make things. All the Raw MAterials have a Raw Material Code eg R1234.

I have a form with a drop down menu which lists all the Raw Material Codes
which are stored in a table. When i click on a code i want it to display a
description of the raw material (which is listed in the same table as the Raw
Material codes) in another textbox.

How do i do this? Im new to Access and havent got much knowledge of it

Any help will be greatly appriciated.
Thanks
 
add the Description field to the combo box (correct name for a "drop down
menu") RowSource. if you don't want to see the description in the droplist,
you can set the ColumnWidth for that column to 0". make sure the ColumnCount
property reflects the total number of columns returned by the RowSource -
including any column(s) that are not visible.

put any unbound textbox control on the form, and set the ControlSource to
refer to the Description column in the combo box's RowSource, as

=MyComboboxName.Column(2)

note that the column count is offset, so column 1 is (0), column 2 is (1),
etc.

hth
 
Back
Top