troubleshooting Question

Userform and Pagetab selection Create unuqie dynamic sql statement based on selections

Avatar of Fordraiders
FordraidersFlag for United States of America asked on
Microsoft Excel
6 Comments1 Solution240 ViewsLast Modified:
Excel 2003
vba

Userform1
MultiPage1
several tabs but specifically  "Page4"
33 option buttons ( using the caption names as my value for the "where" sql statement

I currently have no "Frame"


I need to be able to select no more than 3 option buttons at one time.
They can select only 1 or 2 or 3 option boxes

So using I assume a Case Select statement build my "WHERE" sql statement.

BASIC sql Statement below : For 3 Options chosen

SELECT tblXrefInfo.*
FROM tblXrefInfo
WHERE (((tblXrefInfo.MFRNAME)="NAME1")) OR (((tblXrefInfo.MFRNAME)="NAME2")) OR (((tblXrefInfo.MFRNAME)="NAME3"));

NAME1 2 3  would be substituted for 3 option boxes "Caption Value"


Thanks
fordraiders
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros