For anyone reading this with the same problem, I managed to fix the issue.
In the properties of my subform, Allow Additions and Allow Edits were set to No. I have these now set as Yes and the subform loads quickly. In the VBA code I have set additions and edits to false.
No idea why this was...
I have a form with a subform in it on a tab which pulls out data from a linked table.
This table has a combined primary key.
When I go to the subform it takes quite a while to load all the data. It also reloads itself quite alot too.
When I remove the primary key from the table, the subform...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.