Editing record

[aqif]

Hi

I have a table of country codes........where user can add new country
which is linked field is Patient table. I am concerned that if someone will
edit the existing country name or number then it will disturb everything.
I want that if some one edits the existing record than a msg box comes
which shows the warning abt editing the record...n if user clicks No
button than it changes the record to original value.

Cheers!
Aqif

 

[jwindon]

I could give you the answer on how to do that, but it is the long way around. How about, when giving the option to add a new county and country code, use a form that is set to DataEntry Yes. Therefore, the user can only enter NEW countries and doesn't even see the others. If opening from somewhere else, open the table, form in Add Mode.

Do you think that will serve you better than coding.

You can LOCK the county codes and country name on any other form so that the user cannot edit them. If you WANT to give them that option, You can add a command button that will UNLOCK those fields. The user has to make the consious effort to do so.