Tables Primary Key Effecting Subform

[cameronscrimgeour]

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 runs smoothly without any reloading or problems.

I need the primary key on the table so that I can delete from it.

Why is the primary key causing these problems???

 

[cameronscrimgeour]

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 slowing down my subform but it was.

Hope this helps anyone with a similar problem.