Apr 21 2022 11:38 PM
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 Songs on the album. My only problem is that when the button is clicked, the table that stores the data for the Albums is not refreshed, so when the user goes to enter data in the songs form, and wants to enter the album which the song is on, the Album does not appear. To open the song form, I am using a button with this code; DoCmd.OpenForm "Band", , , , acFormAdd
I was thinking that when that button is pressed, or when the song form is loaded, the album table could be requeried, as well as the field which asks for the album in the song table (Album_ID). I would think that would solve my problem, as after the album data has been entered, the table would refresh and would be available when entering song data. Thanks
Apr 22 2022 06:49 AM
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)
Apr 23 2022 08:56 PM