I have 2 subforms on a Main form. subFormX and subFormY. they both share the same QuestionID number.
So I want to be able to click on the subFormX QuestionID texbox then --- it moves the focus to the record in subFormY that shares the same QuestionID.
Any suggestion on the best way to do this? I played around with docmd.findrecord but had not luck.
Thanks for your help.