B
Beth
Hi,
I have a form that I am trying to re-use to display data from 2 different
tables and the information is changed in the click event from the menu that
selects the form and it sets the recordsource, label captions, and textbox
sources.
This works fine on my userid (the owner), but there are no permissions on
those tables for other user groups. I thought I could get around that using
the "with owneraccess option", but it doesn't seem to be working.
I have confirmed that the owner of both tables has full permissions.
What am I doing wrong?
Thanks,
beth
Here is a snippet of the code that pertains to this question.
Private Sub cmdCategories_Click()
DoCmd.OpenForm "frmSingleEntry"
With Forms!frmSingleEntry
.RecordSource = "SELECT Categories.Category FROM Categories ORDER BY
Categories.Category WITH OWNERACCESS OPTION;"
.Caption = "Categories"
.lblTitle.Caption = "Categories"
.lblItem.Caption = "Category"
.txtItem.ControlSource = "Category"
End With
Exit sub
I have a form that I am trying to re-use to display data from 2 different
tables and the information is changed in the click event from the menu that
selects the form and it sets the recordsource, label captions, and textbox
sources.
This works fine on my userid (the owner), but there are no permissions on
those tables for other user groups. I thought I could get around that using
the "with owneraccess option", but it doesn't seem to be working.
I have confirmed that the owner of both tables has full permissions.
What am I doing wrong?
Thanks,
beth
Here is a snippet of the code that pertains to this question.
Private Sub cmdCategories_Click()
DoCmd.OpenForm "frmSingleEntry"
With Forms!frmSingleEntry
.RecordSource = "SELECT Categories.Category FROM Categories ORDER BY
Categories.Category WITH OWNERACCESS OPTION;"
.Caption = "Categories"
.lblTitle.Caption = "Categories"
.lblItem.Caption = "Category"
.txtItem.ControlSource = "Category"
End With
Exit sub