executing Dlookup result

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 :(
 
A

Allen Browne

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top