UtterAccess Discussion Forums > Multi columned controls on form

Full Version: Multi columned controls on form

UtterAccess Discussion Forums > Microsoft® Access > Access Forms

mmcginley

Aug 2 2006, 09:25 AM

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

Aug 2 2006, 09:26 AM

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.