T
Tom McDonnell
I would recommend creating a function on the form Named
SetFilter() or something similar.
Then in the onChange event of the combo box and the
afterUpdate events of the two text boxes call this
function. Alternatively, if you are going to require the
users to enter the information in a certain order every
time you call the function from the event of the last
field updated.
This function will need to contain all the logic to build
a proper filter string. The filter is just like a SQL
WHERE clause excpet without the WHERE - ex.
DealerName="XYZ" AND Date=#1/1/2003#
After running through all the logic to build the filter
string assign the filter - double check the syntax but it
should be something like
me.subformName.form.filter = strFilter
SetFilter() or something similar.
Then in the onChange event of the combo box and the
afterUpdate events of the two text boxes call this
function. Alternatively, if you are going to require the
users to enter the information in a certain order every
time you call the function from the event of the last
field updated.
This function will need to contain all the logic to build
a proper filter string. The filter is just like a SQL
WHERE clause excpet without the WHERE - ex.
DealerName="XYZ" AND Date=#1/1/2003#
After running through all the logic to build the filter
string assign the filter - double check the syntax but it
should be something like
me.subformName.form.filter = strFilter