Running Code from a Make Table Query

[SteveApa]

Hi All.

I am trying to run a function from a make table query. The make table just pulls in one line from a one line table and runs the code. The purpose of this is so I can see the date the query ran.

The code is to uncrosstab a crosstabed result. In the function I try to execute:
DoCmd.RunSQL "Delete * FROM [" & output_name & "]" to delete the output table before I repopulate it.



I get the error: 2486, You can't carry out this action at the present time."

Why can I not execute this SQL while the make table is running??

Thanks.
Steve

[NoellaG]

You can't empty a pot while you're creating it, just write a procedure that first empties the destination table and then run an append query to repopulete it or you can first drop the table and then recreate it with a make table query.

kind regards
Noëlla