after migrating to sql server one of my form that is a single form with several subforms on the tabs are running slowly. i checked query related to main form is running quickly. also before migrating to sql, running of this single form with subforms were okey. but now opening form takes times and navigating through records of this form is slow while speed of related row source of this form (query) is fast.