I want to apply filter criteria to a query using VBA what the user chooses from any selected combo boxes. The boxes on the form are: County, Block, Section, Well #, and Owner from a tale called tblWllInfo. If the user chooses criteria from County and Section...that would be the filter or if the user chooses Block and Owner then that would be the filter. I'm trying to get away from writing seperate SQL for each instance. I would like to use only one SQL statement for the operation. Can anyone help me out here? [sig][/sig]
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Filter using combo boxes that are not null
- Thread starter aliendan
- Start date
Your code needs to look something like this
dim strSQL as string
strSQL= "SElect....... WHERE"
if not(isnull(me!cboYourCountyComboboxName)) then
strsql= strsql & " County = " & me!cboYourCountyComboboxName & " AND "
end if
if not(isnull(me!cboYourBlockComboboxName)) then
strsql= strsql & " Block = " & me!cboYourBlockComboboxName & " AND "
end if
etc....
You will need to examine your SQL to make sure you built it correctly and you will have to get rid of the final AND, but that should get you started in the right direction. [sig]<p>Kathryn<br><a href=mailto: > </a><br><a href= > </a><br> [/sig]
dim strSQL as string
strSQL= "SElect....... WHERE"
if not(isnull(me!cboYourCountyComboboxName)) then
strsql= strsql & " County = " & me!cboYourCountyComboboxName & " AND "
end if
if not(isnull(me!cboYourBlockComboboxName)) then
strsql= strsql & " Block = " & me!cboYourBlockComboboxName & " AND "
end if
etc....
You will need to examine your SQL to make sure you built it correctly and you will have to get rid of the final AND, but that should get you started in the right direction. [sig]<p>Kathryn<br><a href=mailto: > </a><br><a href= > </a><br> [/sig]
- Thread starter
- #3
[sig][/sig]- Status
Similar threads
