Re: running vba code in a loop



On 29 Sep 2005 16:14:27 -0700, "ken" <gevayl@xxxxxxxxx> wrote:

If I understand you correctly, check out the Eval function in the Help
file:
Debug,Print Eval("3+4")
7

Debug.Print Eval("Field1.ControlSource = 'Documents'")
False

If rather, your intention is to set the ControlSource to "Documents",
then a simple:
Field1.ControlSource = "Documents"
will do.

-Tom.


>Hi,
>Can I run vba code from a string?
>
>Stuff like Field1.ControlSource = "Documents"
>
>Its sort of similar to running an sql...but not.

.