Maco doesn't run queries correctly ALL THE TIME

[mfg2529]

I entered this problem before but can't seem to see this on line so I am entering this again.

My make and append and delete queries work correctly when I run them manually and individually. But when I use a macro, the queries do not always run correctly, i.e. one of my queries does not retrieve any data if I run it via the macro but when I run the query directly, it always retreives the correct data.

I have a form that prompts the user for data and I created an EVENT PROCEDURE against the field to run macro1 if the data entered already exists and to run macro2 if the data is new. In either case, the queries in the macro runs fine for some of the time, but not always. When I run the queries manually, I always get the correct query results.

I am stumped!! There seems to be a cluge of sorts. I tried dumping the data entered by the user to a separate table and
running the macro queries against that temp table but that doesn't work. It seems the only thing that works is to exit the form entirely after every new record entry and go back in but that makes no sense and I can't really do that for a form that will be used heavily live by users.

One of my colleagues has encountered the same problem in the past. Fortunately for him, he can just exit and refresh but my program will be a live program with many users.

I am using MSAccess 2000 by the way.

Would appreciate any help from anyone ASAP!
Thanks!!

 

[dandgard]

You are not giving enough information to understand what your proble
is. Do you get an error message, does the macro halt, or does the dat
not do what you expect. Have you tried single stepping through th
macros???

Have you tried just using VBA - Theres not much you can do in a macr
that you can't do in VBA and you said your already using an even
procedure to decide which macro to run

 

[dandgard]

You are not giving enough information to understand what your proble
is. Do you get an error message, does the macro halt, or does the dat
not do what you expect. Have you tried single stepping through th
macros???

Have you tried just using VBA - Theres not much you can do in a macr
that you can't do in VBA and you said your already using an even
procedure to decide which macro to run

 

[dandgard]

You are not giving enough information to understand what your problem
is. Do you get an error message, does the macro halt, or does the data
not do what you expect. Have you tried single stepping through the
macros???

Have you tried just using VBA - Theres not much you can do in a macro
that you can't do in VBA and you said your already using an event
procedure to decide which macro to run.