Macro conditions stop macro

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TomR - 31 Aug 2006 14:15 GMT

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?

Reply to this Message

Steve Schapel - 31 Aug 2006 19:58 GMT

Tom,

Could you put an unbound textbox on a form which is open at the time
that the macro is run? Then you can get the user to enter the query
criteria in there, and in the design of the query, in the place of the
paramater prompt, you refer to the textbox using syntax such as...
[Forms]![NameOfForm]![NameOfTextbox]

Signature

Steve Schapel, Microsoft Access MVP

> 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
[quoted text clipped - 4 lines]
> just stops regardless if the condition is true or false.
> Is there some way to do this?

Reply to this Message