running vba code in a loop

[ken]

Hi,
Can I run vba code from a string?

Stuff like Field1.ControlSource = "Documents"

Its sort of similar to running an sql...but not.

[Tom van Stiphout]

On 29 Sep 2005 16:14:27 -0700, "ken" <ge****@gmail.com> 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.