RWOP and passing variables to a function

[jaworski_m]

Hello,
I have a table "MyTable" with the following fields:

tableID
valueA
valueB

and a query 'qryMyTable' (RWOP) which is used by a form - all above fields
included.

There is a calculated field on the form which uses a custom function
fMultiply("valueA","ValueB")
which returns a product.

How can I pass variables to the function if I remove all permissions from
"MyTable" (in order to use RWOP query)?

Thank you for suggestions.

 

[Arvin Meyer [MVP]]

There should be no problem unless the user has no permissions on the form.

 

[jaworski_m]

Thank you for the answer.

I'll describe the scenario.
A field on a form uses a function "fConcatChild" to concatenate values from
"many-side" table. "fConcatChild" description can be found here:

http://www.mvps.org/access/modules/mdl0004.htm

One of the parameters which is passed to the function is a table name. The
problem is that unless a user has a permission to read the table the text
field remains blank, because the function cannot read contents of underlaying
table.
I don't want to assign any permissions to tables but build forms on queries
with RWOP.

What is the work-around to read contents of the table used in "fConcatChild"
function?

Thank you hints.

 

[Joan Wild]

You should be able to pass the name of a query instead of the table name.

Joan Wild
MS Access MVP