Hi All,
Have only been using VBA for about a month and in all honesty most of the time I am completely lost and muddle my way through by trial and error looking at all the forum posts and add, alter, copy and delete code to suit (often in error due to ignorance). Unfortunately I am one of those people that decides to learn something new and jumps in with both feet and a complete lack of knowledge about what they are doing ... on the plus side, you guys get to show people like me the knowledge to strive for !
Long story short, I created the attached workbook with a Userform to add new records and view and update existing records. Initially it worked fine and on opening with the "Update Records" button it would open the Userform with blank fields and on clicking the spin button would go to the first (or last) record which could then be updated. Unfortunately now however, I have done something to the code that effectively leaves the Userform broken. Ideally it would jump to the first saved record when opening and the add, update buttons etc would all work as intended, now they don't.
If anyone knows how to fix the attached would be very much appreciated ... even better if you could tell me what I did wrong !
Thanks for taking the time to read !
Bookmarks