UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Multi columned controls on form    
 
   
mmcginley
post Aug 2 2006, 09:25 AM
Post #1

New Member
Posts: 10
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
Go to the top of the page
 
+
fkegley
post Aug 2 2006, 09:26 AM
Post #2

UtterAccess VIP
Posts: 23,583
From: Mississippi
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
Go to the top of the page
 
+
« Next Oldest · Access Forms · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 21st May 2013 - 08:24 PM