Requery Combo Box

[digger27]

I have been through the NG and can't find exactly what I need, though my
question similar to earlier questions.

I have 2 combo boxes in my form.
Combo1 is linked to a table of manufacturers.
Combo2 is linked to a query that uses combo1 as criteria, thus only showing
the model numbers that link to the manufacturer selected in Combo1.

My problem is that I can't get the requery method to work so that when I
change the value in Combo1 I get a new set of models in Combo2. I know that
I need to use code for either the AfterUpdate or Enter event. I have used
code suggested in other posts, but it hasn't worked. Can someone give me the
exact code I should enter? Snippets such as "mycombo.requery" aren't enough
for me as my Access VBA skills aren't that strong.

Thanks in advance.

 

[Lynn Trapp]

You should merely have to put the following code in the AfterUpdate event of
Combo1:

Me.Combo2.Requery

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html