RWOP and passing variables to a function

  • Thread starter Thread starter jaworski_m
  • Start date Start date
J

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.
 
There should be no problem unless the user has no permissions on the form.
 
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.
 
You should be able to pass the name of a query instead of the table name.

Joan Wild
MS Access MVP
 
Back
Top