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

Want to mail report for the current record only

Status
Not open for further replies.

navyjock

Programmer
Jun 5, 2003
1
US
I have a simple access db with 2 forms and 1 report. There is only 1 table. It's not a complicated db.
The report has elements of both forms. When working in a specific record and try to send out a report unique to that record, Access wants to sent the whole record file. I've tried filters and tried to write vb code to see if I could overcome the problem but I've had no success. There's the primary key in the table and an unique id number for each project or record that is provided by another group.
Form 1 feeds Form 2 and they both feed the report. Please help me.
Thanks,
Navyjock
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top