selacted text box for report

[daameta]

hi all,
i have new question. i have a form 'form1' with 5 text box. txt1, txt2 as so far. and report which have above five text box. i want to create chkbox for every txtbox in form1 so when user select txt1 or txt2 chkbox the report show only those data for txtbox1 or txtbox2 and other 3 txtbox will be invisible. is it possible any way please guide me. i think should use cmd button for generate report but i dont know code. any one who suggest any path for this problam.

 

[Uncle Gizmo]

If you look at the "resources" here, https://sites.google.com/site/msacc...iple-copies-of-report-with-different-criteria

You will find a link to a Google presentation which demonstrates a technique you could use.

 

[Uncle Gizmo]

Start at the first slide titled:- "Report Module Code"

 

[Uncle Gizmo]

Basically you use the reports on open event to draw the information you want from your form. (It will work as long as the form is open)

 

[vbaInet]

Start at the first slide titled:- "Report Module Code"

Uncle G, I couldn't find the "Report Module Code" you mentioned. Where should one look?

There's some code in the attached that can be adapted to suit.

 

[Uncle Gizmo]

This might be a better link:- https://docs.google.com/presentatio..._MKcU688XGkftlrOZZjc/mobilepresent?slide=id.p