How to use forms to change a queries criteria

[bjc1007]

This might be an easy one, but it's got me stumped.. I have a form with three combo boxes that you select fields from a value list. The choices in each of the boxes change depending on what you selected in the other two boxes. What I want to do is have each of these three boxes tied to a field in a query, and when you make your selections they become the criteria for that field in the query. Is there a relatively painless solution to this problem?

 

[MichaelRed]

Entirely unclear -at least to me. But I think what you are attempting is straightforward. Add the standard 'criteria' expressions to the query - and have them reference the respective combobox. You DO need to usse the 'fully qualified' name(s) of the combo's (form, control ...).

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over

 

[nabiS2K]

Sure,

Just change my example of MyForm to your form and MyControl to the control on the form that you want to be the criteria:

Forms![MyForm]!MyControl.Value

Hope this makes sense.

God Bless,
Mike

Yes, I believe in Jesus. ;-)
"Neither is there salvation in any other: for there is none other name under heaven given among men, whereby we must be saved." (Acts 4:12, KJV)

 

[bjc1007]

Thanks guys!