Setting subform source object via VBA

[Robbie]

I have a form whose subform is set via VBA. The subform to be used depends on
which button a user clicks to "access" the form. I set the selected subform
via the sourceObject property.

All works fine if the user has administrator permissions. However, if the
user is not an administrator, the following error message is generated:

"You don't have permission to insert this form into another form"

Is this normal? If so, is there another way to allow such a
non-administrator user to run VBA code that changes the subform within a form?

Thanks

ROBBIE

 

[John Smith]

I cannot say that there is no way to do this, but when I tried it a few years
back I eventually gave up and re-designed my UI, everything that I tried was
blocked by Access.

--
HTH
John

I have a form whose subform is set via VBA. The subform to be used depends on
which button a user clicks to "access" the form. I set the selected subform
via the sourceObject property.
All works fine if the user has administrator permissions. However, if the
user is not an administrator, the following error message is generated:
"You don't have permission to insert this form into another form"
Is this normal? If so, is there another way to allow such a
non-administrator user to run VBA code that changes the subform within a

form?