Hello
My userform displays the records when loaded or while navigating the records.Problem is if user clicks on the Save button the form enters the record again. I mean that record is already there in the sheet but as it displays the records from sheet. it also saves them again if the Save button is clicked How can I avoid to enter a duplicate record.The code is bellow:
Best Regards
Please Login or Register to view this content.
Imran Bhatti
Teach me Excel VBA
Any chance you could upload a sample workbook?
Click on GO ADVANCED and use the paperclip icon to open the upload window.
If posting code please use code tags, see here.
You could maybe disable (hide) the Save button when certain codes run. I do that with my Edit and Update buttons.
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
Excel file is attached here. You need to put some JPG photos (name accrding to column A in order to view pictures in the image control.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks