Hi
In my project I reduced the number of subforms to 1 to improve the speed this works very well in Ms Access Backend , but not so good with the SQL server, the cursor take almost a minute to move from the parent form to the sub form. The combos though having over 3500 record are working reasonable well after linking them to views plus the help of the code below:
How did you do it to speed up the cursor movement between parent form and child form?
In my project I reduced the number of subforms to 1 to improve the speed this works very well in Ms Access Backend , but not so good with the SQL server, the cursor take almost a minute to move from the parent form to the sub form. The combos though having over 3500 record are working reasonable well after linking them to views plus the help of the code below:
Code:
Private Sub Product_Combo_Change()
Dim strText As String
strText = Nz(Me.Products_Combo.Text, “”)
If Len(strText) > 2 Then
Me.Product_Combo.RowSource = “Select keywords from ” _
& “ProductName ” _
& “where keywords like ‘” & strText & “*’ ” _
& “order by keywords”
Me.Product_Combo.Dropdown
End If
End Sub
How did you do it to speed up the cursor movement between parent form and child form?