Unanswered: Getting a form to find data and then clicking through to the main table
hi - i have not been able to find this answer.
i am using a split screen form and have 8 fields on the top. when i sort and come up with my list of results on the bottom, can i then select a line and somehow have it launch the main table that the form was created from and just to that data line in the table.
you could open the table with docmd.opentable and then use docmd.searchforrecord to get to your specific record. or create a query which you could open and then filter, so you only see your specific record. or you could have another form which is filtered and only shows the specific record.