running vba code in a loop

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ken - 30 Sep 2005 00:14 GMT

Hi,
Can I run vba code from a string?

Stuff like Field1.ControlSource = "Documents"

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

Reply to this Message

Tom van Stiphout - 30 Sep 2005 05:19 GMT

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.

Reply to this Message