Full Version: Multi columned controls on form
UtterAccess Discussion Forums > Microsoft® Access > Access Forms
mmcginley
Hi

I 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:

Me.[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.