Hello everyone,
I found a problem in one of my databases, which seems to be very simple, but I didnīt find how to run it.
I would like to ask you for help with my problem.
I need to do very special macro, which should run a querry and decide what to da regarding the result.
I have a table called "tblList" and one of the columns is logical type called "ActuallStatus".
I also have a querry "qryActualStatus":
Code:
SELECT tblList.ActuallStatus FROM List WHERE (((tblList.ID)=[Enter ID:]));
This querry has an actuall status of row with entered ID as a result. So there are only two possible results... TRUE/FALSE
Now I need to write a macro which should choose between submacros regarding the result of querryActuallStatus. I tried several ways how to da that, but I failed everytime. For example here is on of my attempts:
Code:
IF [qryActuallStatus]![ActuallStatus] = 0 then
...submacro1
ELSE
...submacro2
END IF
All of my attempts stuck on the same step. Access always throws an error call, where it says its not able to find object qryActuallStatus.
Can you please advice me how to make this macro?
Thank you very much