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!

create report using current record on form page

Status
Not open for further replies.

julius1

Technical User
Oct 31, 2002
142
US
I have a form that I am editing and adding data to, what I am trying to do is to email it off. The problem I have is that when I try to mail the current record after it has been added or edited it pulls up every record and tries to send it using the report I created for that form itself. The form itself has auto populated fields from other forms,it uses a single it is also linked to an orderid key field. I can see the distinct record when I go to that screen but when I hit the email report button the report instead of that current record it spools every record in the data base. If I bring up the report on it's own it also pulls up every record. Can I possibly apply a filter to the report that will allow on the current record to be sent? If so where would I add it?
 
You are on the right track with a filter...However you should realy build a query for your report and set the ctiteria of the query so that it is equal to the field(s) in your form. When you open the report it runs the query and the query reads your form for the criteria before it prepares the report.

I hope this helps.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top