Assigning different subforms to a form using 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