"jaworski_m" <jawors***@discussions.microsoft.com> wrote in message
news:D91C5FCF-9E59-478D-83F0-6B791A5FD599@microsoft.com...
> 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.

> 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.