I want to store the name of procedures in the Access table and want to call depending on the user options. Now ia am unable to call that procedure name from the table For exampl:
table is
Form name proc name
frmsl del_sl
frmpr del_pr
frmprr del_prr
   and so on
Now I want to run del_sl when frmsl is active and selected similarly del_pr when frmpr is active and so on.
Can anyone help at the earliest
Thanks

Hi there..

you can try with call by name... but it's very slow...

what are you trying to do?? maybe there is a better way????

HTH

Gonzalo

    Dim f As Form
    For Each f In Forms
        If f.Name = form_Name Then
            CallByName f, proc_Name, VbMethod
            Exit For
        End If
    Next

Marco

This requires that proc_Name be part of the form referenced by f, right?

That is correct. form_name and proc_name are the strings read from the database, and proc_name must be a method exposed by the form named form_name. The code I posted must be enclosed, as always, in an error handler, because CallByName cannot be resolved at design time (it is in fact a late bound call)
Marco