J
John
Hello all,
I have a date range that filters a combo box. I requery the combo box, and
then I can then select a ProductID from that combo box. Later, I may change
the date range and requery the combo, but the previously selected ProductID
is still shown. That selection, because of the new date range may or may
not still be in the combo list.
I'd rather not clear the combo whenever the date range is changed.
What is the best method, other than a dlookup, to check that the current
ProductID is or is not still in the combo list?
Can I somehow force the Not In List to check?
I did try forcing the AfterUpdate event of the combo box after a date range
change, but that did not fire the Not In List
I will use dlookup if I must.
Thankyou,
John
I have a date range that filters a combo box. I requery the combo box, and
then I can then select a ProductID from that combo box. Later, I may change
the date range and requery the combo, but the previously selected ProductID
is still shown. That selection, because of the new date range may or may
not still be in the combo list.
I'd rather not clear the combo whenever the date range is changed.
What is the best method, other than a dlookup, to check that the current
ProductID is or is not still in the combo list?
Can I somehow force the Not In List to check?
I did try forcing the AfterUpdate event of the combo box after a date range
change, but that did not fire the Not In List
I will use dlookup if I must.
Thankyou,
John