[Forms]![frmNameOfForm].[cboControlName] -- need help w/ exception
- From: "Tom" <anynomys@xxxxxxxxxxxxx>
- Date: Wed, 27 Apr 2005 09:56:22 -0400
In a login form with 2 cascading combos. Their selected values will be
used in a query to subselect matching records. I use the following strings
in my query criteria:
- [Forms]![frmLogin].[cboState]
- [Forms]![frmLogin].[cboCity]
This process works fine and I get the proper results.
However, I am now dealing w/ a unique scenario. Let's say the 2 selected
values for cboState and cboCity are identical (e.g. "New York" | "New
York").
In this case, I don't want to find the records where New York exists in
field "State" AND field "City". Instead, I want to use "New York" as the
query criteria for yet another field (let's call this field "Exception").
Is there a way to create a smart query or SQL code that does look at the
values in both combos? And again, if they are the same, use either
selected value (State or City) as the criteria for a 3rd field.
Any suggestion how this could be accomplished?
Tom
.
- Follow-Ups:
- Re: [Forms]![frmNameOfForm].[cboControlName] -- need help w/ exception
- From: [MVP] S.Clark
- Re: [Forms]![frmNameOfForm].[cboControlName] -- need help w/ exception
- Prev by Date: Not Enough Space On Temporary Disk
- Next by Date: Re: Which identity?
- Previous by thread: Not Enough Space On Temporary Disk
- Next by thread: Re: [Forms]![frmNameOfForm].[cboControlName] -- need help w/ exception
- Index(es):
Relevant Pages
|
