I did not know that. I just figured that the combo box was a collection of sorts that maintained an index behind the scenes with which to determine the bound value.
To combine would also mean I would have to separate back out since I use the 2 columns for 2 different arguments.
But thanks Duane.
Respectfully,
Liz Ravenwood
Programmer / Analyst
B/E Aerospace | Super First Class Environments
1851 S Pantano Road | Tucson, Arizona 85710
Office +1.520.239.4808 |
beaerospace.com
Passion to Innovate. Power to Deliver
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Duane Hookom
Sent: Wednesday, July 10, 2013 10:22 AM
To: Access Professionals Yahoo Group
Subject: RE: [MS_AccessPros] combo box Access bug?
I'm not sure I understand but if your combo box is bound to the first column, every one of the values in the first column should be unique. If not, you will not get consistent results. You have multiple items in the combo that would have the same value.
I would minimally combine the two columns into a single expression (column width of 0) and use this unique combination as the bound column.
Duane Hookom MVP
MS Access
----------------------------------------
> From: liz_ravenwood@beaerospace.com
>
> Pros, I think I found an Access bug but I still need to work around it.
>
> I have a combo box with this query at the data:
>
> SELECT ReportCode as Selection, "Program" as Selected FROM
> ProgCodesActive UNION SELECT AffectedArea as Selection, "Area" as
> Selected FROM AffectedAreasAndEmailsNogales;
>
> And yields results like this:
>
> Selection
> Selected
>
> Asiana
> Area
>
> Asiana
> Program
>
> BA
> Area
>
> BA
> Program
>
> Emirates
> Area
>
> Emirates
> Program
>
> Etihad
> Area
>
> Etihad
> Program
>
> Etihad A380
> Program
>
> Etihad B787
> Program
>
> Garuda
> Area
>
> Garuda
> Program
>
> JAL
> Area
>
> Japan B777
> Program
>
> However, I can IMMEDIATELY check what was selected and if I select the Emirates/Program, I can see that it is reset to Emirates/Area. My subsequent code doesn't work by calling column 1 as an argument because it isn't set.
>
> Call SetQueryDef("All", Nz(Me.cboType, ""),
> Nz(Me.cboReportCode.Column(1), ""), Nz(Me.cboReportCode, ""))
> DoCmd.OpenQuery "forReports" & strWho, acViewNormal, acReadOnly
>
>
> Respectfully,
> Liz Ravenwood
------------------------------------
Yahoo! Groups Links
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (6) |
Tidak ada komentar:
Posting Komentar