E
Eric
My issue is that i'm using a form with 4 filters at the same time.
the filters are combo boxes that are filled using queries on a table.
my data are returned by another query on the same table but containing
the 4 fields corresponding to the filters.
when i choose the second filter and when the result returns no row the
selected value of the second filter briefly appear and then disappear
from the combo box. the data are properly filtered but the combo
remains empty even if i change the first filter and that the result
have one or more rows. the second filter is still empty but the data
are well filtered.
did someone have any advice or work around to avoid this issue.
thanks in advance for any help
Eric
the filters are combo boxes that are filled using queries on a table.
my data are returned by another query on the same table but containing
the 4 fields corresponding to the filters.
when i choose the second filter and when the result returns no row the
selected value of the second filter briefly appear and then disappear
from the combo box. the data are properly filtered but the combo
remains empty even if i change the first filter and that the result
have one or more rows. the second filter is still empty but the data
are well filtered.
did someone have any advice or work around to avoid this issue.
thanks in advance for any help
Eric