Textbox trubles

[MGrowneyARSI]

Hello I have a text box That I would like to display both text and variables in I'm puting this code in the control source but I can quite seem to get it to work the two variables are public and set = to dlookups and work fine but the textbox kepps getting errors
="Please select between " & [MinVar] & " - " & [MaxVar] & " peers to administer your 360 surveys."
I'm sure I missing something simple here any help is more then welcome
TIA

[FishVal]

Hello I have a text box That I would like to display both text and variables in I'm puting this code in the control source but I can quite seem to get it to work the two variables are public and set = to dlookups and work fine but the textbox kepps getting errors
="Please select between " & [MinVar] & " - " & [MaxVar] & " peers to administer your 360 surveys."
I'm sure I missing something simple here any help is more then welcome
TIA

Hi, there.

I'm not sure Access allows to include variables even global one in ControlSource expression. You may need to write global function returning that global variable. LOL.

[MGrowneyARSI]

That would explain why the code works in a MSGBox but not the textbox I'll give it a try.

[MGrowneyARSI]

Well in the end I just set the textbox = text var1 - var2 text in the on open event works great now, what was my boss talking about LOL thanks for the help seems you were right can't do it in the Control Source thanks for pointing me in the right direction unlike my boss.

[FishVal]

You are welcome.

Regards,
Fish