[AccessD] combo box 101

Rusty Hammond rusty.hammond at cpiqpc.com
Mon Aug 8 10:37:04 CDT 2011


Should your column widths then be 0";0";3" ? 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William
Benson (VBACreations.Com)
Sent: Monday, August 08, 2011 10:32 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] combo box 101

This ought to be a piece of cake. I have a combo with rowsource:

Select 	Source, 
	Level1Basis as [Customer Level], 
	ReportName
from 
	TblReportHeaders
where 
	Source = [forms]!frmMatchReport![cboBasis] 
	and 
	level1basis = [forms]!frmmatchreport![cbobasislevel1]

Columncount = 3.
In terms of the display problem I am having, it doesn't seem to matter
whether ColumnWidths is left blank, or I enter 0.5";1.5";3".
What I want to show in the text portion of the combo is the 3rd field,
[ReportName]

But what keeps being displayed after a selection, is the 1st column
(Source)

Bound Column has been alternately set to 0, 1, or 2 ... it makes no
difference.

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
**********************************************************************
WARNING: All e-mail sent to and from this address will be received,
scanned or otherwise recorded by the CPI Qualified Plan Consultants, Inc.
corporate e-mail system and is subject to archival, monitoring or review 
by, and/or disclosure to, someone other than the recipient.
**********************************************************************




More information about the AccessD mailing list