Validation rule text

For the attached Database, I have the table validation rule:

IIf([More MgSO4?]="Yes",Not IsNull([extra dosage]),IsNull([extra dosage])) And
IIf([anti HyperT agent?]="Yes",Not IsNull([anti HyperT dosage]),IsNull([anti HyperT dosage]))

This works until you try to make a correction on a previously saved record. I tried to test this validation rule but it gets stuck on the validation text message. How do I get out of this please??

e.g. if you double click on TripID 325874 of the subform, the PreEclampsia form will auto populate. Leave "More Magnesium given?" as "Yes" and delete the dose already provided. The validation text message pops up and wouldn't go away even after you've corrected the error. Same thing for the Hypertensive agent/dose

PLEASE HELP!:banghead:

You would have much more control over your validation if you did it using VBA behind the Form. Have you considered that?

@GinaWhipp, Cindy says: "Yes I have but I gave up on the idea"

http://www.access-programmers.co.uk/forums/showthread.php?t=267220

hey! I didn't say that. Well, I guess my actions said so. I'm juggling many balls in the air and I think I'm too saturated to absorb new knowledge right now. I tried to code it but kept getting a compiler error. That is why I shifted to using a table validation - less hassle

Cindy,

Hmm, so here is what I heard... I decided it was quicker and easier to dig a 2,000 foot foundation and build the 3,000 square foot house. I know the house will problably fall down later but I'll worry about that then.

The table validation is not easier because you have less control and it doesn't always do what you want, case in point, your initial post. If you're having trouble with the code, well, that's why we are here, to help. So, my advice, throw one or two of those balls to someone else and do this right or this ball will hit the ground and bounce right into your bosses office!

Table validation is *flaky*... period, code is flexiable. What you are trying do needs to be done via code.