Subforms and security

[EricTheRed]

A quick dilemma to resolve in my continuing quest to produce a functional database:

I have a main form, on which is a single subform. Based on certain settings chosen on the main form, the source object of the subform changes. This is all fine and good - under admin access. However, if I log on to the database as a user with more limited permissions (specifically, read-only), I am unable to change the source object. I get the error 2614, "You don't have the permission to insert this form into another form." Is there any way to temporarily circumvent the security? Or will I be forced simply to stack my different subforms and adjust visiblity based on the settings?

Any help would be greatly appreciated. Thanks in advance!

 

[Autoeng]

You are getting this message as the user doesn't have permission to change form design and that is basically what you are doing when you select the alternate subform to display. I think that you are going to have to do what you indicated unless someone else knows an alternate method.

 

[EricTheRed]

I tried several work-arounds to no avail. No matter, however. I have since implemented a tabbed view instead and that seems to be working nicely. Thanks anyhow.

 

[Nouba]

use the With Owner Access option with stored queries for your forms.