By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,136 Members | 1,949 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,136 IT Pros & Developers. It's quick & easy.

38 Combo Box's into one criteria

ChaseCox
100+
P: 294
I would like to take a model # and divide each alpha-numeric value into its own combo box. I would then like to filter the column where the model numbers are by the values in each of the combo boxes. They need to remain in order, 1 - 38. Does anyone know how to do this?
Nov 30 '06 #1
Share this Question
Share on Google+
5 Replies


ChaseCox
100+
P: 294
To add onto what I was saying, this is what I am trying to do.
m 4 0 blank
combo1 combo2 combo3 combo4


If I wanted the person using the form to be able to select all possible 38, or just 3 or 4, How would that need to be coded. something like

combo1combo2combo3 or combo1,combo2,combo3, I need some serious help with this one.
Nov 30 '06 #2

ChaseCox
100+
P: 294
To add onto what I was saying, this is what I am trying to do.
m 4 0 blank
combo1 combo2 combo3 combo4


If I wanted the person using the form to be able to select all possible 38, or just 3 or 4, How would that need to be coded. something like

combo1combo2combo3 or combo1,combo2,combo3, I need some serious help with this one.

I figured it out. Thanks though, here is my solution

SELECT [Odyssey Mat Baseline 5_31_06].PART_PART_NBR, [Odyssey Mat Baseline 5_31_06].PROD_CODE, [Odyssey Mat Baseline 5_31_06].[SHIP DATE], [Odyssey Mat Baseline 5_31_06].[CLAIM DATE], [Odyssey Mat Baseline 5_31_06].[DATE STARTED], [Odyssey Mat Baseline 5_31_06].[DATE FAILED], Mid([ORDERED_MODEL],1,38) AS Expr1
FROM [Odyssey Mat Baseline 5_31_06]
WHERE ((([Odyssey Mat Baseline 5_31_06].PART_PART_NBR) Like ("*" & [Forms]![Form1]![cmbpn] & "*")) AND (([Odyssey Mat Baseline 5_31_06].PROD_CODE) Like ("*" & [Forms]![Form1]![cmbpc] & "*")) AND (([Odyssey Mat Baseline 5_31_06].[SHIP DATE]) Between [Forms]![Form1]![cmbsd] And [Forms]![Form1]![cmbed]) AND (([Odyssey Mat Baseline 5_31_06].[CLAIM DATE]) Between [Forms]![Form1]![cmbcd] And [Forms]![Form1]![cmbcde]) AND (([Odyssey Mat Baseline 5_31_06].[DATE STARTED]) Between [Forms]![Form1]![cmcsd1] And [Forms]![Form1]![cmcsd2]) AND (([Odyssey Mat Baseline 5_31_06].[DATE FAILED]) Between [Forms]![Form1]![cmcfd1] And [Forms]![Form1]![cmbfd2]) AND ((Mid([ORDERED_MODEL],1,38)) Like ("*" & [Forms]![Form1]![cmbm1] & [Forms]![Form1]![cmbm2] & [Forms]![Form1]![cmbm3] & [Forms]![Form1]![cmbm4] & [Forms]![Form1]![cmbm5] & [Forms]![Form1]![cmbm6] & [Forms]![Form1]![cmbm7] & [Forms]![Form1]![cmbm8] & [Forms]![Form1]![cmbm9] & [Forms]![Form1]![cmbm10] & [Forms]![Form1]![cmbm11] & [Forms]![Form1]![cmbm12] & [Forms]![Form1]![cmbm13] & [Forms]![Form1]![cmbm14] & [Forms]![Form1]![cmbm15] & [Forms]![Form1]![cmbm16] & [Forms]![Form1]![cmbm17] & [Forms]![Form1]![cmbm18] & [Forms]![Form1]![cmbm19] & [Forms]![Form1]![cmbm20] & [Forms]![Form1]![cmbm21] & [Forms]![Form1]![cmbm22] & [Forms]![Form1]![cmbm23] & [Forms]![Form1]![cmbm24] & [Forms]![Form1]![cmbm25] & [Forms]![Form1]![cmbm26] & [Forms]![Form1]![cmbm27] & [Forms]![Form1]![cmbm28] & [Forms]![Form1]![cmbm29] & [Forms]![Form1]![cmbm30] & [Forms]![Form1]![31] & [Forms]![Form1]![32] & [Forms]![Form1]![33] & [Forms]![Form1]![34] & [Forms]![Form1]![35] & [Forms]![Form1]![36] & [Forms]![Form1]![37] & [Forms]![Form1]![38] & "*")));
Nov 30 '06 #3

NeoPa
Expert Mod 15k+
P: 31,660
Must this be a static SQL string.
If you set this up using VBA from within the form's module, then you can append only the relevant parts of the WHERE clause - leaving out any which are not selected on the form.
This can have huge performance advantages when working with large tables.
I'm pleased to hear you've got it working anyway.
Dec 1 '06 #4

ChaseCox
100+
P: 294
Must this be a static SQL string.
If you set this up using VBA from within the form's module, then you can append only the relevant parts of the WHERE clause - leaving out any which are not selected on the form.
This can have huge performance advantages when working with large tables.
I'm pleased to hear you've got it working anyway.

how would you do that?
Dec 1 '06 #5

NeoPa
Expert Mod 15k+
P: 31,660
That depends so much on what you want.
What do you have now?
Dec 1 '06 #6

Post your reply

Sign in to post your reply or Sign up for a free account.