filter combo drop down menu

[HL]

I want to filter the drop down menu of [combo B] with the value of [control
A]. It will be like show only the items in the drop down menu of [combo B] if
the value of [field 1] in [combo B] matches the value of [control A].

I find that the menu only change when I go to the next record even when I
have put the Requery command in the "on current" and "after update" events of
the form.

Is there anything wrong?

Thanks a lot for your help!!

 

[Al Campagna]

HL,
If you are using the value of A as a criteria in B, you should do a
Requery on the AfterUpdate event of combo A.
Form OnCurrent is too early, and form AfterUpdate is too late.

--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."