38 Combo Box's into one criteria

[ChaseCox]

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?

[ChaseCox]

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.

[ChaseCox]

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] & "*")));

[NeoPa]

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.

[ChaseCox]

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?

[NeoPa]

That depends so much on what you want.
What do you have now?