make report - data from unbound text box; how? (1 Viewer)

[Janjang]

as a title, how? coz i want make report based on value that calculated at form where data value is unbound..


i use ms access 2K

i make calculation on my form.. and ofcoz the result is in unbound textbox.. but when i try to make report of the result, it need table or query to make it..

so i fugure out how to make report where data is from unbound text box (result from calculation)


TQ

 

[Malcy]

Hi
As long as the form is open you can get to the data in the textbox by using
[Forms]![frmMyForm]![txtMyTextbox]
Where frmMyForm and txtMyTextbox are changed to the names from your application.
If you simply wanted to use the value you would put a textbox on the report and make its source
= [Forms]![frmMyForm]![txtMyTextbox]

Hope this helps
Good luck

 

[Janjang]

Hi

= [Forms]![frmMyForm]![txtMyTextbox]

do u mean bound textboxt in report with this?

thanks

 

[Janjang]

thanks, it works..

 

[Malcy]

Cool
Glad to have been of help