T
TomR
I am trying to prevent my append query from executing if the number of
records returned by a query (which is the first macro step) returns more than
one record.
DCount("[Tno]","TrucknoQuery")>1
This works if the criteria for the TrucknoQuery is typed in the query
design. If I promt the user to enter criteria when the query runs, the macro
just stops regardless if the condition is true or false.
Is there some way to do this?
records returned by a query (which is the first macro step) returns more than
one record.
DCount("[Tno]","TrucknoQuery")>1
This works if the criteria for the TrucknoQuery is typed in the query
design. If I promt the user to enter criteria when the query runs, the macro
just stops regardless if the condition is true or false.
Is there some way to do this?