I am using a continuous form to search for a records via multiple search criteria just like Rich did in his Search Form 2.0.  This is working great BTW!
I then followed Rich's conditional formatting video to highlight a selected record.

My continuous form only includes a select set of available fields.  I.E. First Name, Last Name, State, and Customer Since.

I quickly got tired of needing to opening another 'Customer Form' to see the full record data, I.E. Address, phone #, notes, etc.  In the footer of my continuous form I managed to add these additional fields limited to and based on the record that is selected in the continuous form using Dlookup.

The database has been split and the backend tables are on a network drive.

This appears to be working for the most part.  It is however noticeably slower since adding the "extended information" using dlookup.  Even highlighting different records when selected.  My database has less than 750 records.

Is there way to get the same result without using dlookup to improve performance?