Recent content by Danners

I have managed to fix it after a bit of fiddling, I had my Private blnGood As Boolean line at the wrong part of my code - I didn't realise it had to be above everything including the bit of code I have for pulling data from another table. Thank you for your help - it's much appreciated :)

Yes I did that and changed it to my command button name - however this is not working and will not allow me to save and move onto the next record

Hi arnelgp, Thank you for this. It works for discarding the changes when I close the form or database. However this code also brings up the 'discard changes?' message when I click the save button, which I don't want it to do - If the user clicks the save button I just want it to do this and...

Hi, thanks for responding. I have had the me.undo command in various iterations of code I have tried, but not sure where to combine the me.dirty part. As I say I am new to all this, and don't fully understand what I am writing. If you could provide an example of what that combination would...

Hi all, I know a couple of users have had this same issue, and I have had a look around many of the posts on the issue and tested some of the code but I cant get it to work properly. Please bear with me, I'm fairly new and self taught to this stuff so it has mainly been trial and error. I...