M
mscertified
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?
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?