Hi,
I have a pop-up form on which there is a command buton linked to an "update query". Everytime the button is clicked, it makes a record to the table. I want to prevent from someone accidentally clicking twice (or more times) and making more than one record. I was thinking of finding a way to lock the command button after it is clicked once. Then unlocked when the form is closed and opened back on...Is this doable? How could that be done?
Any advice is greatly appreciated.
Rgds.
Atol
I have a pop-up form on which there is a command buton linked to an "update query". Everytime the button is clicked, it makes a record to the table. I want to prevent from someone accidentally clicking twice (or more times) and making more than one record. I was thinking of finding a way to lock the command button after it is clicked once. Then unlocked when the form is closed and opened back on...Is this doable? How could that be done?
Any advice is greatly appreciated.
Rgds.
Atol