IF I DON'T FIND OUT HOW TO LINK TWO COMBO BOXES I WILL DIE A TERRIBLE DEATH

Codesmith

New member
Local time
Today, 22:28
Joined
Apr 19, 2001
Messages
7
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!!!
 
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
 
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
 

Users who are viewing this thread

Back
Top Bottom