Call a procedure

J

JimS

I want to call a subroutine whose name is a column in a table. So, for a
given row, the table would specify the routine I am to call to process that
row. How do I do that?
 
K

Klatuu

I would not recommend naming them the exact same name. That can confuse us
human types and on occassion Access.

I don't quite understand what you are asking. Is the name of the sub to
call the value in a field or is it the name of the field. Can you give a bit
more detail.
 
J

JimS

I'd have a table like:
Description......Routine
Update Stuff subUpdateStuff
Delete Things subDeleteThings

etc.

When the user chooses, for example, "Update Stuff" from a combo box, I would
execute a sub called "subUpdateStuff" in vba.

I think it's the "callbyname" method if I understood someone else's post
earler.
 
K

Klatuu

Actually, the way you are doing it, the Eval() function would work.

Call Eval([UpdateStuff])
 
Top