Hi all
This is my first post on here, so please be gentle!
I am a relative newcomer to Access 97 (which we still use at work), and have created a form which includes customer records. However, what I have now been asked to do is beyond me. One of the fields can be either empty or populated. I have been asked to ensure that if the field is empty it cannot be amended, but if it is populated, it can be changed if necessary (but not to an empty field). I currently have it set up as an enabled/unlocked text box, so it can be amended whether empty or populated.
Is there any way of doing what I have been asked? If you know the answer, please treat me like I'm an idiot and make it very simple to understand!!!
Many thanks for taking the time to read this.
Regards
Ed
This is my first post on here, so please be gentle!
I am a relative newcomer to Access 97 (which we still use at work), and have created a form which includes customer records. However, what I have now been asked to do is beyond me. One of the fields can be either empty or populated. I have been asked to ensure that if the field is empty it cannot be amended, but if it is populated, it can be changed if necessary (but not to an empty field). I currently have it set up as an enabled/unlocked text box, so it can be amended whether empty or populated.
Is there any way of doing what I have been asked? If you know the answer, please treat me like I'm an idiot and make it very simple to understand!!!
Many thanks for taking the time to read this.
Regards
Ed