table validation again
- Thread starter Cindy
- Start date
Just trying to test/break it before the users wreck it irreparably
I uploaded it in a new thread but here it is again. Your help is greatly appreciated
http://www.access-programmers.co.uk/forums/showthread.php?t=267361
I uploaded it in a new thread but here it is again. Your help is greatly appreciated
http://www.access-programmers.co.uk/forums/showthread.php?t=267361
hi vbaInet, in the database which I uploaded yesterday, opening a record in the subform (by double clicking on TripID) will populate a tab page. I am only concerned with the Preeclampsia page. My validation rule says that if [More Magnesium given?] = "Yes" then the dose should be provided in the [extra dose] field. It should not be blank.
e.g. if you double click on TripID 325874 of the subform, this will auto populate the Preeclampsia form. Here, "More Magnesium given?" is "Yes" but try deleting the dose already provided and saving it. 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. :banghead:
e.g. if you double click on TripID 325874 of the subform, this will auto populate the Preeclampsia form. Here, "More Magnesium given?" is "Yes" but try deleting the dose already provided and saving it. 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. :banghead:
