I have a userform with the following code in a Cancel button. The trouble with it is if I make any changes in the text boxes on the userfrom then hit cancel it will save those changes. How can I get it to cancel and not save any changes?
Please Login or Register to view this content.
that code won't save anything on its own. unless your textboxes are changing the cells as soon as they are changed (either in code or because they are directly bound to the cells) or you have code in the queryclose or terminate events, changes should not be saved.
Josie
if at first you don't succeed try doing it the way your wife told you to
Thanks Joesph I see the problem now. I use ControlSource in the text box properties to link the cell with the text box so when the form is opened it displays the current information. It updates the cells as I tab from box to box.
Is there another way of doing this?
yeah, you need to use code to populate the textboxes and put the data back in the cells when you click Save (I assume you have a Save button?)
so like this
and clear the controlsource properties from all the textboxes. usually better to not link controls directly to cells.Please Login or Register to view this content.
Thanks Joseph that fixed it, I in inserted this line of code and it's all good.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks