Setting ControlSource propoerty in code 1

[barrylowe]

I am trying to set the controlsource property of one of my text boxes in code when a button is clicked.

I want to set it to the returned value of a rather complex DCount function. However to start off I'm just trying to set it to a text string and I can't even manage that.

I am using the line:

Me.txtFilteredWaitingListTotal.ControlSource = "Test"

This line has been written into the form_load event but when the form opens up the textbox is displaying #Name?

Any help appreciated.

 

[traingamer]

try:

Me.txtFilteredWaitingListTotal.ControlSource = "=""test"""

(The same as typing ="test" into the property.

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[barrylowe]

Works a treat mate, thanks very much.