I have a check box that when selected will highlight another Text box which I then need to put in an amount ($). This amount I want copied into yet another Text box which contains other information I have provided.
I have tried to use the IIf function but I am obviously not succeeding.
In the Text box I have the formula as follows:
IIf([Combo23]=True, "[Text23]")
All this formula results in is '[Text23] because that's what is in the inverted commas. How can I get the actual $ amount to go into the text box.
Thankyou so much for your help.
I have tried to use the IIf function but I am obviously not succeeding.
In the Text box I have the formula as follows:
IIf([Combo23]=True, "[Text23]")
All this formula results in is '[Text23] because that's what is in the inverted commas. How can I get the actual $ amount to go into the text box.
Thankyou so much for your help.
