BIGmiralli Frequent Poster
Joined: 17 Apr 2007 Posts: 38 Location: Boston, Massachusetts
|
Posted: Fri May 23, 2008 9:20 am Post subject: Prevent Unwanted Edits |
|
|
If you are trying to make a form secure so that edits are only made after an "Edit" button is pressed then:
1. Change your backgroudn color to gray
2. Lock each text box
3. Make an "Edit" button with the following code:
Code: | Me.tbxName.BackColor = RGB(255, 255, 255) 'White
Me.tbxName.Locked = False |
4. On the forms "OnCurrent" event put the follwoing code:
Code: | Me.tbxName.BackColor = RGB(216, 216, 216) 'Gray
Me.tbxName.Locked = True |
________
Vaporizer wholesaler |
|