filter combo drop down menu

H

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!!
 
A

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."
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding Fields To A Combo Box Does Not Work - Field Reverts To FirstValue In List 1
combo box based on a combo box 1
Limit lookup results by relation to current record 1
How to filter out the same values in the drop-down list of a combo 5
Simple Combobox 1
Help with requery/update 4
Combo box bound column 3
multiple filters 4

Top