Parameters

[Luis]

Hello.
I have a function that performs an action that i'd like to
use on several tables. The only thing diferent is the name
of the table and the field to work on.
I use a recordset to do this action.
I was thinking of having a Sub or Function that calls the
function i've mentioned with two parameters, the table
name and the field to work on.
On the table name theres was no problem, but i have a
problem on the field name. I don't seem to be able to use
the parameter on the recorset.
Is it possible to pass field names as parameters? If so
how can i pass them and use them on a recordset?

Thanks.

 

[Allen Browne]

The example in this link shows how to build a SQL statement by passing in:
- an expression (typically a field name);
- a domain (typically a table name);
- some other choices as well.

See:
http://members.iinet.net.au/~allenbrowne/ser-42.html