Liz-
What are the Bound Column and the Column Count of the combo box? Is your
code running in the combo AfterUpdate event?
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Liz Ravenwood
Sent: Wednesday, July 10, 2013 5:11 PM
To: 'MS_Access_Professionals@yahoogroups.com'
Subject: [MS_AccessPros] RE: combo box Access bug?
Crap. Email did something weird to my table.
The results go like this:
Selection Selected
Emirates Area
Emirates Program
Etc.
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 Liz Ravenwood
Sent: Wednesday, July 10, 2013 8:09 AM
To: 'MS_Access_Professionals@yahoogroups.com'
Subject: [MS_AccessPros] combo box Access bug?
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
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
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.
[Non-text portions of this message have been removed]
------------------------------------
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.
------------------------------------
Yahoo! Groups Links
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar