Combo Boxes

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

Guest

I would like to create a combo box that has two columns ... one column takes
the value NSN from the table NSN and the other column takes the value Price
from the table NSN. I would like both values to appear when you select a
certain NSN so that the price shows with it. I can't seem to get the correct
code in order to make this happen. I am using Microsoft Access 2003.
 
First, change the combo's RowSource to something along the lines of

SELECT NSN & " - " & Price, NSN, Price FROM TableNSN

Then change the BoundColumn to 2, the ColumnCount to 3 and the ColumnWidths
to soemthing like 0.1, 2, 4 (the point being to make column 1 width to samll
to be seen in the dropdown.

Hopefully, you will see the NSN and the Price information when the drop down
is clicked and both should appear when an item is selected.

Hope This Helps
Gerald Stanley MCSD
 
Back
Top