>Have you tried to use Lookup function instead? It seems to me, that it would be perfectly suited for your situation.
Callme() has to:
- return two concatenated fields from employee table - see the code I posted
- restore the work area, the order, the record pointer... all data environment
as I explained in the message
- work with any table (including the employee table) as the main table, i.e. the table the form is editing or the report is printing.
I don't see how lookup is suited for any of the above - but am willing to listen...
Thanks for your effort.
dz
Doru