pass-through

[zezo2021]

Hello
I need to speed subform I have more than 3 subforms
I want to bound this subform to a pass-through query
but access prevents me to do that
what is the solution

 

[Pat Hartman]

Why do you think this will speed up the subform? Are you aware that pass-through queries are not updateable so the subform would not be updateable? Do you have the master/child links set? Can you reduce the number of rows the subform returns? Are all three forms visible at once? If not, remove the RecordSource and add it when you make the subform visible.

 

[zezo2021]

thanks for the great information

 

[Pat Hartman]

If anything you tried helped, please let us know.