M
Mark Senibaldi
Hi,
I have a macro that runs a set of queries. There is one query for each
record on a form which is bound to a table. Each record is a name(for the
sake of explanation) and each query appends 1 name to a master table. I have
a checkbox on each record of the form. When I run the macro, I only want the
queries to run that have a checkmark in the check box on the form. Currently
the conditions are only looking at the last record. How can I make each query
in the macro look at each related record on the form and if the box is check,
run- if the box is not checked then don't run?
I have a macro that runs a set of queries. There is one query for each
record on a form which is bound to a table. Each record is a name(for the
sake of explanation) and each query appends 1 name to a master table. I have
a checkbox on each record of the form. When I run the macro, I only want the
queries to run that have a checkmark in the check box on the form. Currently
the conditions are only looking at the last record. How can I make each query
in the macro look at each related record on the form and if the box is check,
run- if the box is not checked then don't run?