combo box help

[realnine]

I have a db that stores info on autobobiles. THe pertinent tables are:
Maketable - one field labeled make
Modeltable - two fields labeled make, model

In the main form I want to have a lookup combo box for make and then have a lookup table for model which shows only the modes for the make selected in the make lookup.

I have sucessfuily done this by putting this the the row source for the molel pookup box
SELECT Modeltable.Model, Modeltable.Make FROM Modeltable WHERE (([Modeltable]![Make]=[Forms]![Dispatch]![Make]));

My problem if I go back and enter another make in the make lookup box, the model lookup remaines on the first make.

For example, I seledt Ford from the make lookup box. Then the lookup box shows all Ford models. Now, if I go back and change the make to GMC, when I go to the model box it still shows all models of Ford.

I suspect I need a requery code somewhere bu I don't know haow to do that.

I am new to this forum and read all the many post oncascading comb boxes. Lot of evry knolwdgeable people on the forum.

Thanks

 

[WayneRyan]

realnine,

You can use the BeforeUpdate event for your Make combo
to do:

Me.YourModelCombo.Requery

hth,
Wayne

 

[realnine]

Thanks Wayne,
That is what I neede but I had to put it in the AfterUpdate event of the make lookup box.

I noticed typos in my original post for which I am sorry. I am 70 years old and have authritis in my hands, so please excuse me.

Thanks