executing Dlookup result

  • Thread starter Thread starter Aika
  • Start date Start date
A

Aika

How can i made execute dlookup returned text. I got
textbox with controlsource =dlookup (bla bla) .. which
return text: "today is " & date() ! But i need to execute
tis text, lika countrolsource is ="today is " & date()
sorry for my english :(
 
The ControlSource property has to be a string, so:

Dim strSource As String
strSource = "=DLookup(""[SomeField]"", ""[SomeTable]"")"
Me.MyTextBox.ControlSource = strSource

I think that's what you need. If not, Eval() may help.
 
Back
Top