As the title implies, I have a main form and a subform i.e frmMain, frmMain_sf with a Combo Box on the frmMain listing all of the records listed in frmMain_sf. The record source for the subform is a stored query with no record source for frmMain.
I want to select a value in the Combo Box and go to that record on the subform. I would also like to highlight the record found in some manor i.e. different row color.