[AccessD] A couple of macro questions

My first advice would be to convert the macro to VBA code so you can see
precisely what is happening. Macros in general are an inadequate approach,
IMO.
A.

On Tue, Aug 11, 2009 at 10:19 AM, Kaup, Chester <
Chester_Kaup at kindermorgan.com> wrote:

> I have a macro with warnings turned off. One query when I run it outside
> the macro and it tries to append records to a table I get the message key
> violation cannot append 3 records do you wish to continue. When it runs in
> the macro what happens. Does it append only the records it can or what?
>
> In this same macro I run a number of queries and then open a report in
> print preview. The report has a close form button on it. When I click the
> close form button the results of the query that the report is based on comes
> up. I thought it should go back to the form that called the macro to run.
> How do I get it to close the query and go back to the first form.?
>
>