473,394 Members | 1,746 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 software developers and data experts.

Query returns incorrect results

I have two drop down boxes, for the fields "County" and "Category" on
a form which when selected for the respective County and Category will
return Agency Names of Agencies within the respective County and
Category.

For example, when I select Cook County and Cardiovascular disease I
expect the query(ies) behind the form to return Names of Agencies in
Cook County that provide services regarding Cardiovascular care.

However, what is returned are Names of Agencies outside of the county
and category selected.

What is wrong? What must I fix?

Thanks,

John
Aug 26 '08 #1
3 2058
I assume the dropdown boxes are, in fact, combobox controls not listbox
controls.
Are the properties of the combo boxes set to Limit To List = Yes?
Does your query re-execute in the After_Update event of BOTH controls?
Fred Zuckerman

"zufie" <jo***********@illinois.govwrote in message
news:65**********************************@b2g2000p rf.googlegroups.com...
>I have two drop down boxes, for the fields "County" and "Category" on
a form which when selected for the respective County and Category will
return Agency Names of Agencies within the respective County and
Category.

For example, when I select Cook County and Cardiovascular disease I
expect the query(ies) behind the form to return Names of Agencies in
Cook County that provide services regarding Cardiovascular care.

However, what is returned are Names of Agencies outside of the county
and category selected.

What is wrong? What must I fix?

Thanks,

John

Aug 26 '08 #2
Precise, concise questions usually get the best answers. In your case, a
precise question would have mentioned how you use the values from the combo
boxes. As it is, the answers to your questions would be:
What is wrong?
Almost certainly, your implementation.
What must I fix?
As you only described, vaguely, what forms, controls, and subjects, it would
be difficult to be more specific.

Would you care to clarify? On the assumption that you tell us what you
have, in detail, that is going wrong, I would make a further assumption that
someone here can offer useful suggestions.

Larry Linson
Microsoft Office Access MVP

"zufie" <jo***********@illinois.govwrote in message
news:65**********************************@b2g2000p rf.googlegroups.com...
>I have two drop down boxes, for the fields "County" and "Category" on
a form which when selected for the respective County and Category will
return Agency Names of Agencies within the respective County and
Category.

For example, when I select Cook County and Cardiovascular disease I
expect the query(ies) behind the form to return Names of Agencies in
Cook County that provide services regarding Cardiovascular care.

However, what is returned are Names of Agencies outside of the county
and category selected.

What is wrong? What must I fix?

Thanks,

John

Aug 27 '08 #3
On Aug 27, 12:43*pm, "Larry Linson" <boun...@localhost.notwrote:
Precise, concise questions usually get the best answers. *In your case,a
precise question would have mentioned how you use the values from the combo
boxes. *As it is, the answers to your questions would be:

*What is wrong?

Almost certainly, your implementation.

*What must I fix?

As you only described, vaguely, what forms, controls, and subjects, it would
be difficult to be more specific.

Would you care to clarify? *On the assumption that you tell us what you
have, in detail, that is going wrong, I would make a further assumption that
someone here can offer useful suggestions.

*Larry Linson
*Microsoft Office Access MVP

"zufie" <john.marru...@illinois.govwrote in message

news:65**********************************@b2g2000p rf.googlegroups.com...
I have two drop down boxes, for the fields "County" and "Category" on
a form which when selected for the respective County and Category will
return Agency Names of Agencies within the respective County and
Category.
For example, when I select Cook County and Cardiovascular disease I
expect the query(ies) behind the form to return Names of Agencies in
Cook County that provide services regarding Cardiovascular care.
However, what is returned are Names of Agencies outside of the county
and category selected.
What is wrong? What must I fix?
Thanks,
John- Hide quoted text -

- Show quoted text -


Sorry, here is my VBA code for all the controls (2 combo boxes and 1
checkbox)

John

Option Compare Database
Option Explicit
Private Sub Check13_AfterUpdate()
If Me![Check13] Then
Me![Combo3].Enabled = False
Me![Chicago Zip].Enabled = True
Else
Me![Combo3].Enabled = True
Me![Chicago Zip].Enabled = False
End If
End Sub
Private Sub ToggleLink_Click()
' Me![Combo3] County
' Me![Combo9] Category
Me.Requery
If Me.NewRecord Or (Me![Check13] And IsNull(Me![Combo3]) And IsNull(Me!
[Combo9])) Or _
(Me![Check13] And IsNull(Me![Chicago Zip]) And
IsNull(Me![Combo9])) Then
Forms![Sub: Agency Lookup].DataEntry = True
Else
If Me![Check13] Then
If IsNull(Me![Combo9]) Then
Forms![Sub: Agency Lookup].RowSource = "qry Agencies by Zip"
ElseIf IsNull(Me![Chicago Zip]) Then
DoCmd.OpenForm "Sub: Agency Lookup by Category", , , ""
Else
DoCmd.OpenForm "Sub: Agency Lookup by Zip Category", , , ""
End If
Else
If IsNull(Me![Combo9]) Then
DoCmd.OpenForm "Sub: Agency Lookup by County", , , ""
ElseIf IsNull(Me![Combo3]) Then
DoCmd.OpenForm "Sub: Agency Lookup by Category", , , ""
Else
DoCmd.OpenForm "Sub: Agency Lookup by County Category", , , ""
End If
End If
End If
End Sub
Aug 28 '08 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

9
by: Chris Greening | last post by:
I'm seeing a very strange problem with outer joins. The example below replicates the problem: create table data1 (dim1 integer, stat1 float); create table data2 (dim1 integer, stat2 float); ...
8
by: Bruce Dodds | last post by:
When run manually, my query appends 14 records. When run from code using CurrentProject.Connection.Execute, the same query appends 11 records. Does anyone have an explanation of why this could be...
0
by: Ahmed | last post by:
Hi, I'm an Access newbie and I'm trying to create a simple report binded to a query which is: SELECT survey.q0_sex AS Gender, Count(survey.q0_sex) AS FROM survey WHERE q0_sex<>"" GROUP BY...
2
by: Matt Michael | last post by:
I'm using ADO .NET to connect to a Microsoft Access database, and everything so far has been working in my program except one small problem. I am constructing a query string to search for certain...
4
by: seegoon | last post by:
Hi to all. I am pretty new to this stuff , so forgive me if I am asking the obvious. I am trying to extract some data from an Access database and am having some trouble. The SQL query that I am...
6
by: bill.mckinstry | last post by:
I have simple Select Query using two small tables. Table A includes Statement ID & Date. Table B includes Statement ID, Loan ID & Payment Amount. The Query selects payments and amounts from Table...
1
by: `Zidane Tribal | last post by:
it would appear that using the command 'crc("data")' from the String::CRC returns incorrect results (although, they are at least consistently incorrect). for example, this script..... ...
0
by: serhii7777 | last post by:
Hi, I have a report, which includes several subreports based on specific queries. Sometimes, one of the queries returns no result, which leaves a blank spot on a report. Is there a way to put a...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.