I currently have an Access database where the a user can search for a loan number and if that loan appear is present in the database the matching record displays on a subform. The user can then double click on the loan number to open the record in a form (which is based on a query). Basically, the double click event procedure opens the form and filters to the correct record using the code below:
DoCmd.OpenForm "frmqryData", , , "[Number]= '" & Me.[Number] & "'"
The issue I am having is now that the database contains almost 150k records, this process to open the record and can take 30-45 seconds. Is there a faster way or better way to open the record in the form? The database is split to backend and front (linked tables) using Access 2003.