I have a form with a subform that feeds off the same table. I'd like the user to be able to click a button in the subform and have the main form jump to that record.
When I try this using the wizard, the main form jumps to the desired record just fine, but it is filtered. Is there a way to code this so my users don't end up in a one-way street? Put another way, is there a way to leave the main form at the desired record and still have the navigation buttons work properly?