John W. Colby
jwcolby at colbyconsulting.com
Thu Jan 27 10:36:40 CST 2005
Are the format properties set properly in the combo itself? Usually the problem is not enough columns specified ot column widths of 0. John W. Colby www.ColbyConsulting.com Contribute your unused CPU cycles to a good cause: http://folding.stanford.edu/ -----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