M
Mrs. Ugh
I have a secured database with a form containing a subform. I want to display
a different subform based on which user is logged in. I entered code in the
form's "on open" event that checks the user and sets the subform's source
object to the appropriate subform. It works great, when I am logged on as the
administrator. When I log on as someone else, I get an error "2614: You don't
have permission to insert this form into another form."
I changed permissions to give users the permission to modify the form, but
got the same error. I tried setting the subform source to [OpenArgs] and
opening the form via a module, but I got the same error. Any ideas (other
than creating 2 separate forms)?
Thanks,
Jill
a different subform based on which user is logged in. I entered code in the
form's "on open" event that checks the user and sets the subform's source
object to the appropriate subform. It works great, when I am logged on as the
administrator. When I log on as someone else, I get an error "2614: You don't
have permission to insert this form into another form."
I changed permissions to give users the permission to modify the form, but
got the same error. I tried setting the subform source to [OpenArgs] and
opening the form via a module, but I got the same error. Any ideas (other
than creating 2 separate forms)?
Thanks,
Jill