Look Up Dropdown Values Based on another control

[Dave K via AccessMonster.com]

I would like to restrict the user's choices for a field (drfile.cusip) based
on the selection they make in another field (drfile.plan_id), which is
Combo26 on my form. I have set this SQL statement as the row source:

SELECT drfile.cusip FROM drfile WHERE (((drfile.plan_id)=[Forms]![Add Manual
Trades]![Combo26]));

This works great on the first record, but for every record thereafter it
ignores the value the user puts in the current record's Combo26 and only
displays the values for the first record. How can I get this to work
properly?

Thanks,
Dave

 

[SteveD]

I'm trying to remember ----- using the onEnter property of the combo box,
place a requery command like ... me.combobox.requery

This way the combo box is "ready" each time.

HTH,
SteveD

 

[Dave K via AccessMonster.com]

That did it! Everything else said to requery after update on the first combo
box. Thanks a bunch, SteveD!

-Dave

I'm trying to remember ----- using the onEnter property of the combo box,
place a requery command like ... me.combobox.requery

This way the combo box is "ready" each time.

HTH,
SteveD

I would like to restrict the user's choices for a field (drfile.cusip) based
on the selection they make in another field (drfile.plan_id), which is

[quoted text clipped - 10 lines]

Thanks,
Dave