I have a subform in Datasheet view with a very simply OpenForm code that links to another form:
DoCmd.OpenForm "Applicants", , , "ClientID = '" & Me.ClientID & "'"
Only problem is that when I click to open, it opens only the highlighted entry of the subform, which in most cases is the first entry in the subform. I realised that I have to click on the particular subform entry, then click the "GoTo" box I created to open the right form.
Is there any simple coding I can add where, upon clicking the "GoTo" box, it will highlight the entry first? I have attached the problem in a screenshot to help explain?