Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

create report based on infor in form

Status
Not open for further replies.

worktermstudent

Technical User
Oct 4, 2002
1
CA
I am trying to have an option on a form that you can produce a report based on the forms info.

I have a form that where you enter information on training courses(date, location, course, facilitator). And there is a different form where you enter registration information for people registering for these training courses.

I want to be able to print a report that shows all the people registered for this particular course. How do I do this?
 
Have the Report button reference a query that pulls the information you need from the tables. To the user it'll look like if came from the form - but forms only DISPLAY what's in the tables behind them (or from queries and calculations, etc). Reports have to get the info from somewhere, just like a form does, since they too only DISPLAY. See?

C
*~*~*~*~*~*~*~*~*~*~*~*~*
Insanity is a matter of Perception. [yinyang]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top