Open Form to Specific Record in Whole Recordset
Ok, I have a form where I double-click on a record in a subform and that opens the next form with more detailed information about that record. This is no problem and works.
The problem that I am faced with is that when this happens, I get 1 record, filtered and I can't scroll to the next or previous record, I have to go back to previous form and select the next record by double clicking. If I just open the form and display all records, the first record is automatically displayed. And then I have to scroll through the records until I find the one I want, defeating the purpose of the previous form.
I'm looking for a way to be able to open a specific record on the form by double clicking on the previous form, yet still maintain the ability to scroll both forward and backward through the entire record set from that record. Am I making sense? Is there a way to do this?
Ok, I have a form where I double-click on a record in a subform and that opens the next form with more detailed information about that record. This is no problem and works.
The problem that I am faced with is that when this happens, I get 1 record, filtered and I can't scroll to the next or previous record, I have to go back to previous form and select the next record by double clicking. If I just open the form and display all records, the first record is automatically displayed. And then I have to scroll through the records until I find the one I want, defeating the purpose of the previous form.
I'm looking for a way to be able to open a specific record on the form by double clicking on the previous form, yet still maintain the ability to scroll both forward and backward through the entire record set from that record. Am I making sense? Is there a way to do this?
Last edited:
