Combo box intricacies !?!

[Guest]

I have 3 combo boxes on my form A,B,C.
B is dependent on A and C is dependent on B.
They are bound to an id but display text via a query which I dynamically
manipulate.
I do stuff in code such as switching the row source and auto setting the
value if there is only one dependent value.
The other complexity is that this table column has an associated 'active
swich'. People can be active or inactive.
When I'm on an existing record, I change the rowsource query to return only
the active people plus the current value. When I'm on a new record, the query
returns only the active people. The idea is to prevent setting a value to an
inactive person but to still display inactive people already set.
All of this is mostly working ok.
A problem arises, however, when the user attempts to use the FIND command,
some values are not being found. I'm assuming this is because my current
rowsource is not returning the value.
Is there a better way to do this?

 

[Rick Brandt]

I have 3 combo boxes on my form A,B,C.
B is dependent on A and C is dependent on B.
They are bound to an id but display text via a query which I
dynamically manipulate.
I do stuff in code such as switching the row source and auto setting
the value if there is only one dependent value.
The other complexity is that this table column has an associated
'active swich'. People can be active or inactive.
When I'm on an existing record, I change the rowsource query to
return only the active people plus the current value. When I'm on a
new record, the query returns only the active people. The idea is to
prevent setting a value to an inactive person but to still display
inactive people already set.
All of this is mostly working ok.
A problem arises, however, when the user attempts to use the FIND
command, some values are not being found. I'm assuming this is
because my current rowsource is not returning the value.
Is there a better way to do this?

The built in FIND commands are mostly for very simple apps. I would
recommend you build a mechanism of your own that allows the user to do
filters and searches and remove any access to the built in stuff. Then you
are in complete control over how those features work.