Forum Discussion
Requerying with Vba
Hi All, just got a small problem. I have a form (For Albums), that the user will enter data in. At the bottom of the form is a button that takes them to another table, which allows them to enter Song...
Hi,
Try to save the new album record by inserting this line above the DoCmd.Openform:
If Me.Dirty = True Then Me.Dirty = False
Servus
Karl
Access News (new March episode)
Access DevCon (April 28+29)
Hi Karl, Just wondering, If a user enters two albums, then goes back to the first album, clicks this button with the above code, I noticed that the second album will not save yet. I guess this won't really be a problem for the user, it just could be a little confusing. I did notice that closing the form will save all records, but that creates the problem where when I want to reopen the Album form from the Song form, to the same Album, it will not. I think I will stick with the code you have provided. Thank you!
