[AccessD] RE: A2k2 combo boxes / rowsource hassles

Did you remember that the Columns property is Zero based?

.Column(0) = first column
.Column(1) = second column
etc.

Neal

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Tom Bolton
Sent: Thursday, January 27, 2005 11:23 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] RE: A2k2 combo boxes / rowsource hassles


Hi guys

 

I have a problem with setting the rowsource property of a combo at runtime -
I'm binding it to the SQL query shown below:

 

SELECT tblAdmin_ColumnLookup.Alias, tblAdmin_ColumnLookup.FieldName,
tblAdmin_ColumnLookup.[DataType] FROM tblAdmin_SQLData INNER JOIN
tblAdmin_ColumnLookup ON tblAdmin_SQLData.ID = tblAdmin_ColumnLookup.SQLID
WHERE tblAdmin_SQLData.ReportID = 5 AND
tblAdmin_ColumnLookup.IncludeInTemplate=True

 

The first 2 columns are there using myCombo.Columns(x), but the third...
nowhere to be seen.  I'm tearing my hair out here!!

 

Any help appreciated, TIA

Tom 

 

 

 

Tom Bolton

Systems Developer (I.T.)

Donns Solicitors

Tel: 0161 834 3311

Fax: 0161 834 2317