Control reference in query grid

[Tom Stoddard]

I've finally narrowed down my problem to this:

I set up security on the BE tables of my database so that some users have
read only and others have full permissions to the tables. I created a simple
form based on a query on 1 table. Both users could use the form.

I then added a combobox based on a simple query on one other table. I tested
the form and both users could still use it.

I then put a reference to the combobox in the criteria field of the query
grid of the query that the form is bound to and put this code "Me.Requery"
in the combobox onAfterUpdate event. When the user with full permissions
uses the form the user can change the selection in the combobox and the form
requeries and filters the records it displays. When the user with read only
permission on the tables tries to open the form its blank. Non of the
controls are visible.

I even tried using the Form's Filter property instead by putting "CustomerID
= [Forms]![frmTest]![cboCustomer]" in the filter property and setting
Me.FilterOn = True in the form's load event. I got the same result. It
worked for the user with read/write access but not for the user with read
only access.

Can anyone explain this to me?