create report using current record on form page

[julius1]

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?

 

[JoeEskimo]

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.