Form opens SLOW when "Allow Addtions" set to No

  • Thread starter Thread starter Redstone
  • Start date Start date
R

Redstone

I have a frontend with some fairly complicated forms (lots of tabs). It
took me some time to figure out - but when I set the "Allow Additions"
attribute to "No" the form takes 45 seconds to open. When I set the
attribute back to "Yes" it only takes 5 seconds. I'm thinking this
attribute must be interacting with another attribute. Could that be it
or is it something else?
 
Could be quite a lot of things.

Work through each of the items in the Access Performance FAQ at:
http://www.granite.ab.ca/access/performancefaq.htm

That should solve it, but if you are still stuck I guess you could leave
Allow Additions as Yes, and cancel the BeforeInsert event of the form
instead:
Private Sub Form_BeforeInsert(Cancel As Integer)
Cancel
MsgBox "Nah: no new ones please."
End Sub
 
Back
Top