Full Version: Multi columned controls on form
UtterAccess Discussion Forums > Microsoft® Access > Access Forms
mmcginley
Hi
have a control on one of my forms with two columns (Country and CountryOfCurrency).
If i am writing a SQL statement for another control how do i refer to a specific column on the combo box.
Any Help much appreciated
Cheers
fkegley
Use the Combo Box's Columns collection:
e.[NameOfComboBox].Column(ColumnNumber)
ColumnNumbering starts at 0 so to get the second column, you would put a 1 for ColumnNumber
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.