Limit selections in Combo while continuing to display old selectio

[Guest]

In a subform, users make selections from a dropdown list (Combo Box) that
displays values from a table, tReviewName.

Records in tReviewName contain an indicator, indReviewActive.

Can I limit the current selection choices to those where indReviewActive =
True, while continuing to display older rows with indReviewActive = False?

Thanks,
Bill

 

[John W. Vinson]

Can I limit the current selection choices to those where indReviewActive =
True, while continuing to display older rows with indReviewActive = False?

One somewhat finicky way to do so is to put a bound textbox on the
form, carefully aligned so that it is superimposed over the text area
of the combo box. Set the textbox with Enabled = No, Locked = Yes, Tab
Stop = No so the user can't select it; the combo will drop down "in
front" of the text box when you select the dropdown arrow.

John W. Vinson [MVP]

 

[Guest]

Thanks John -- Finicky, maybe. Clever - very. I'm still missing part of the
answer, though.

When I display both the combo box and text box side by side, combo drops
down what it's supposed to, and text box displays what it should. Everything
looks and behaves properly. But when I superimpose the text box over the
combo, the text of the combo doesn't show.

What am I missing?