From a subform using a command button I want to call the corresponding form and subform.
I am able to call the correct form using:
DoCmd.OpenForm "Work Enter", acNormal, "", "[ArtistID]=[Screen].[ActiveForm].[ArtistID]", , acNormal
The name of the subform is Work Subform.
Using WorkID as a connector, can someone help me with some code that will call the corresponding file.
I hope I have made my question clear, but as is the case others on this forum, I am a beginner.
Any help with this question will be greatly appreciated.
I am able to call the correct form using:
DoCmd.OpenForm "Work Enter", acNormal, "", "[ArtistID]=[Screen].[ActiveForm].[ArtistID]", , acNormal
The name of the subform is Work Subform.
Using WorkID as a connector, can someone help me with some code that will call the corresponding file.
I hope I have made my question clear, but as is the case others on this forum, I am a beginner.
Any help with this question will be greatly appreciated.