VBA Statement

[Guest]

I have a Access Database that I'm writing code, that will preform a If
Statement:

When "Vendor" or name is choosing, on click run the Query. I have several
Query save for each Vendor that has defferent calulation with in the query. I
would like to open up the a Query from a list of Queries. Can I use a
If.....Then....Else Statement?

Please asist.

Jeff

 

[Guest]

It might be easier to create a pop-up form with a list box on it. The On
Click event would trigger the query when an item is selected.

Hope this helps...

 

[Guest]

And read "Using Select Case Statements" in Visual Basic for Applications help.