doubts and more doubts

[Tauri]

Hi.

I have a command button and some text boxes and i want that wend a click on the command button the information on the text boxes show up on a report.

How do i do that???

Thank.

 

[GaryPanic]

Right what you want is a tick box option
if the tick box is true then text will appear on your report

So build your report first with all of the fields you require -
now add a yes/no option to your table - tie this to your form with a tick box
and a little bit of coding if tick box = yes then table yes/no option = yes/true else no
now put this tick box on your report properties visible .no
now you have a trigger on your report

in your report details properties its build or then code builder or build code
if tickbox = true then whatever txt field = true which will be something like
textfield.visible=true
and if tickbox=false then textfield.visble=false

end if might need 2 of these

that should do it

 

[Tauri]

Im going to try it

Thanks

 

[doco]

Been around Access since 2.0; VB since the beginning. Doesn't mean I know it all, doesn't mean that I know anything really. But, what is a 'tick box'? CheckBox or RadioButton AKA OptionButton?

 

[GaryPanic]

A tick box or variations of it - is a way of stating :
Yes/no
True False
0/-1

this simple method then can be made in to a trigger

if tickbox= true/yes/0 then do something
if tickbox =false/etc do something else or don't do the above

now you could as easliy had if text box = yes then do x and have a list/combo box do the same thing - however - visually a tick box is smaller - good for when the question-option is yes/no

now if you had more options than yes/no then a list /comob is better suited
yes/no/unsure

and a bit of coding for each answer

HTH
g