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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

printing one record off of subform

Status
Not open for further replies.

mcginnism

MIS
Nov 18, 2002
5
US
I have a main form with pulls information about signs. Then I have a sub form that contains the work order information for those signs. I want to be able to print the form but only the current record. I tried print current record but what it does is it prints the current record of the main form but every record of the subform. I want only the current record of the main form and the current record of the subform. Is there a way to do that? Thanks
 
Well I looked around the forum and found some info on my problem. I know now that I have to create a report. But how do I get the report to show the info that I selected. This is how my database works. I have the following tables. Post inv, sign inv, work order. there is one post for multiple signs. I have a query that matchs the sign inv and post inv tables together. That query is the record source for my main form. Then the work order table is the record source for my sub form. The work order and query are tied together by the sign number. The user looks up the sign number with a lookup combo box. Then they enter the work order information in the subform. I wanted to be able to print the current form and current subform but it prints the current form and every record in the subform. So I know that I need to make a report but how do I set up the report to show just the info that I want. Is there a way to have a button on the form that will open the report with the info filled in from the form? Please help!!!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top