Form opens SLOW when "Allow Addtions" set to No

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Redstone" wrote in message
oups.com...
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?