Conditional prompt for data entry

[thr33xx]

Hello,

I have a data entry database which has 4 text fields for data entry.

Date | Weight | SBP | DBP

I would like to enforce a conditional prompt on 3 of these 4 fields - weight, SBP, and DBP. I would like to setup a conditional prompt where if values entered into these fields are less than or greater than a set range, a prompt pops upon clicking the Add record button asking the user if they certain the values they inputted are valid. For example, if I have a valid range for weight set between 100-300, and a user inputs a value of 85, clicks the save record button, a prompt would appear asking the user "You have entered a value which may not be valid, is this value correct?" Then the user would be given the option of Yes or No, where Yes would add the record, and No would ask the user to reinput the correct value.

I am still learning Access, any help would be greatly appreciated!

Thanks

 

[spikepl]

look at the form's BeforeUpdate event. Inside the handler , do all the checks for you conditions.

If not all your conditions are met, inside the handler just say Cancel=True, and data will not be stored in the db