Evaluating a variable

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to determine the contents of a variable given the variable name as a string?

I'm trying to do something like the switchboard with a column I'll call Paramter. This column will contain something like "[ProductId]=?". I can parse the string so that I have a variable (FormParam) that equals "ProductId", and I want to find out what Me.ProductId contains.
 
Use Eval(FormParam) to evaluate the expression contained in the string
variable FormParam, i.e., this will return the contents of ProductID when
FormParam="ProductID" or "Me.ProductID"

Paul Johnson

H Robert King said:
Is there a way to determine the contents of a variable given the variable name as a string?

I'm trying to do something like the switchboard with a column I'll call
Click to expand...
Paramter. This column will contain something like "[ProductId]=?". I can
parse the string so that I have a variable (FormParam) that equals
"ProductId", and I want to find out what Me.ProductId contains.
 
Back
Top