MS Access, Calling a procedure using a variable name

Calling a procedure using a variable name

Author	Message
Neville Sat #1 / 2	Calling a procedure using a variable name I need to call a procedure in a form. Using the " Call Forms!xxx.Btn_Click()" constuct works but I need to be able to specify both the form and the button as variables. I need something like the following : tmp_form = "xxx" tmp_button="Btn" and then Run / Docmd "Call Forms!" & tmp_form & "." & tmp_button & "_Click()" Is there any way I can get something similar to work under vba. tia Neville
Sat, 13 Sep 2003 12:47:17 GMT

Pedro G #2 / 2	Calling a procedure using a variable name Hi, Try looking at the Eval Function... On Tue, 27 Mar 2001 14:47:17 +1000, "Neville Satz" Quote: >I need to call a procedure in a form. Using the " Call >Forms!xxx.Btn_Click()" constuct works but I need to be able to specify both >the form and the button as variables. >I need something like the following : > tmp_form = "xxx" > tmp_button="Btn" >and then > Run / Docmd "Call Forms!" & tmp_form & "." & tmp_button & "_Click()" >Is there any way I can get something similar to work under vba. >tia >Neville --------- Pedro Gil http://www.geocities.com/pmpg98_pt DDPI http://www.users.bigpond.com/papwalker/DDPI.HTML https://sourceforge.net/projects/ddpi/
Fri, 12 Sep 2003 19:14:23 GMT

Page 1 of 1

[ 2 post ]