Hello, I'm in the midst of creating the mother of all databases and an unexpected dilemma has thwarted my attempt. I have two combo boxes. The first one selects a Make, and the second one selects a Model. I need to produce a list of models only for that paticular make in the second box. I lied and Im not actually a Codesmith, nor have I been using access very long. My second combo box pulls its value from a query where only those vehicles which match the first selection are produced, but it only selects values for the model which was displayed when the form was opened. I am doing a requery for Model, but still... I get the same result. If anyone can save my life please help!!!

In the after update of Combo1 put Me.Combo2.Requery
HTH

I tried what you said, but Im still only getting the [Combo2] Results for the [Combo1] value that was there when the form was opened.

?

It sounds to me, after you have tried Rich's suggestion, that combo1 is not filtering the query for combo 2. Recheck that combo1 is in fact filtering the query for combo2

I Figured it out.
Yippie!!!, thanks for the help Rich.

Hi there!

I too am working on a database with a similar feature that the CodeSmith has described. I can create two unbound combo boxes that will requery brilliantly but I am not having much success at make the second combo box bound to a field in a table. The field is available in the form selection box but when I make the change from unbound to bound, Access does not recognize the criteria selection in the query.

Does anyone have any ideas?

Thanks
JONP

jonp, I had problems somewhat similar to codesmith's, and member 'llkhoutx' created and sent me a small sample. It helped me out a great deal. If you're still having problems, email me and I'll send you that sample database.

Richie