Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Filter using combo boxes that are not null

Filter using combo boxes that are not null

Filter using combo boxes that are not null

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?

RE: Filter using combo boxes that are not null

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


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.


RE: Filter using combo boxes that are not null

Yes, that's it!  I wasn't removing the ()'s placed there by the query builder.  Once I removed the ()'s the errors quit and it all worked just great.  Thank you, Kathryn, for clearing my head.  

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close