evaluating code that is held in a string

[MarkGreen]

Hi,
Is there any way of, having looked up a String value from a table, evaluting it in visual basic. It seems the eval function isnt sufficient to eval commands such as

"forms!form1!control1 = 2"

Any help is greatly appreciated!!
Mark

 

[Zathras]

It's tricky, but you could loop thru all of the controls on the form, find the one you want by name (you would have to parse the string to extract the name). Then by setting an object you should be able to update the text/value property.

An alternative would be to set up a case structure so that you can select the appropriate case by the name of the control (parsing is still up to you) and set the property within the case. Something like

  nValue = 2
  Select Case sControlName
    Case "control1"
      forms!form1!control1.Value = nValue
  End Select

Kind of depends on how many controls you're working with.