I have code in the On Current event of a subform that loads a pdf associated with that record into an ActiveX control on the Main form. The problem is that the focus moves from the subform to the ActiveX control and I can't get it back to the subform without clicking on that record again. How can I either return to the record on the subform or never leave it in the first place? Here's what I'm using (feel free to recommend a different method):
Private Sub Form_Current()
'Load Incorrect File
Dim sIncorrectScan_Path As String
sIncorrectScan_Path = "Q:\A_DPW\Images\SewerTieCards\" & [Address] & ".pdf"