[AccessD] Re: Combo on Continuous Form

The Current would filter each time he tabbed into that control, which might
become a nuissance after awhile, but would be quite cool if that's what he's
actually after. 

Susan H. 

Mark:

I'd use the on current event to structure an SQL statement based on the
appropriate values in the current record.  The set the combo rowsource and
requery the combo box.

I'm assuming that if the user clicks the combo box of a record which is not
the current record the OnCurrent event triggers first so the combo box row
source will be reset and requeried before it drops down.

Otherwise you may have to put the code into the OnClick event of the combo
box, or even the GotFocus event on the theory that the user could tab into
the box.

But I would try the OnCurrent first.