I like your idea.
However, I have a Combo Box on the form that displays the Base Name. I don't see where I can "filter by tcnoid" It is bound to Base_Name. My main form has a combo box with base_name and a command button for TCNO.
I want to select a base from the combo then click on TCNO...