Table update confirmation

[jkoer]

I have a table column, that for every time I enter a number into the field, I want a text box to pop up that says "Is this correct?" Basically I need to make sure that when people enter in data, that it is the correct number, that they will then need to double check and click "yes". Any help would be greatly appreciated.

 

[boblarson]

That is what forms are for. With forms you can validate entry and you can stop it from happening if it isn't supposed to. Users should not have direct access to tables or queries. They should be working in forms.

 

[plog]

I agree with bob, but want to add what you are doing is pointless. You're 'validation' method isn't going to have any effect on erroneous data being entered. People are going to learn that after every time they enter data they have to automatically click an annoying button. Maybe the first time it pops up they read it, but after that it becomes an automatic reaction to entering data that they pay no real attention to.

 

[mdlueck]

People are going to learn that after every time they enter data they have to automatically click an annoying button.

Just like websites which require double email addy submission... I paste my email addy into BOTH fields on such sites!

 

[Pat Hartman]

If there is any way to actually validate the number you should do that. For example, you might check that it falls within a certain range or it is higher (or lower) than the most recent entry (you'll need an identifier and the table will need an autonumber or timestamp so that the records are "sequenced").