execute string as vb statement

[Guest]

Is it possible to execute a string variable as a VB statement?

 

[Guest]

See Access Help for the Eval() function

 

[Marshall Barton]

Is it possible to execute a string variable as a VB statement?

No.

But, if you'll explain more about what you're trying to do,
maybe someone can come up with an alternative approach.

 

[Guest]

I am trying to set the record source of a subform on a form but the same
needs to run for two different forms. I was hopeing to pass the form name
and concatenate it to the string and execute the string. I.E.
"Forms!" & formname & "!subformname.form.recordsource=select x from tablex"

 

[Dirk Goldgar]

I am trying to set the record source of a subform on a form but the
same needs to run for two different forms. I was hopeing to pass the
form name and concatenate it to the string and execute the string.
I.E. "Forms!" & formname & "!subformname.form.recordsource=select x
from tablex"

If it's just the form name you want to get from a variable, you're in
luck. This works:

Dim strFormName As String

strFormName = "frmFoo"

Forms(strFormName)!YourSubformName.Form.RecordSource = _
"SELECT X FROM TableX"

 

[Guest]

Thank you this did work very well.

If it's just the form name you want to get from a variable, you're in
luck. This works:

Dim strFormName As String

strFormName = "frmFoo"

Forms(strFormName)!YourSubformName.Form.RecordSource = _
"SELECT X FROM TableX"

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)