hi, i have two querys different querys, from the same table, that i am using as subform in a new form. i need the two querys to be filtred by the Date field, they both have, using the same value for both.
i have to try to do it by vb code, setting a variable, and asking for it when the main form loads, and then creating the filter for each subform using that variable, but when i run it, i get at the bottom "filtred" but they are not filtered, i still get all the records.. any ideas??
thank You very much
Eli
i have to try to do it by vb code, setting a variable, and asking for it when the main form loads, and then creating the filter for each subform using that variable, but when i run it, i get at the bottom "filtred" but they are not filtered, i still get all the records.. any ideas??
thank You very much
Eli
