Been trying to improve upon my search form and well, I have a sample here but can't get it working correctly
I have the main form with 2 subforms
The main form has the search criteria, the first subform is in Datasheet view. The apply filter applies it to the datasheet subform. I have it set that if you select the record and double click it should open that record in the 2nd subform.
That is where the issue is. I can't get it to do it. When you doubleclick the "very first record" it opens it just fine. Any other record, it doesn't.
Not sure where I am wrong. I am posting that dB here.