rwop and combo lookup table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have split my db into BE/FE. There are no permissions assigned on tables
on BE to group AppUsers. This group has full permissions on FE to tables,
forms, queries. I have converted all my tables to rwop queries and use them
in all my forms. It has been successful except for a combo box lookup table.
I have two forms - an update form and a search form. Both forms have a
combo box linked to the same rwop query. Both the update form and the search
form are opened from a main form. I am able to open and lookup(use) the
combo box value in the update form. When I try to open the search form I
get, "Record(s) cannot be read. No read permission on tblVendor".

Don't understand why the rwop (lookup) query works fine on one form and not
the other.

Thank you,
LBN
 
Back
Top