rwop and combo lookup table

L

LBN

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Clearing combo boxes and a text box 2
RWOP and passing variables to a function 3
Trying to remove error from conflicting code 0
Creating a Search using a combo box and then creating a report. 4
Adding data to MS Access from csv file 0
Dynamic Naming of Form Button 3
Combo or list box 0
rwop 4

Top