Whenever I click into a list box and select an item, it changes all of the text box controls to " #Error "
The text box controls have a control source of the following:
But slightly different for each one. Why when I click in the list box to these suddenly change? And how do I correct it?
Thanks
Adrian
The text box controls have a control source of the following:
Code:
=Format("3/1/"+[cboYear].[Text],"dddd")+" 3rd"
But slightly different for each one. Why when I click in the list box to these suddenly change? And how do I correct it?
Thanks
Adrian