Search results for query: *

Thanks a lot. I'll give this a try. I'm not sure exactly how to link the report to a query, but I think I can figure it out. I'll let you know. Thanks again, Hal S.

I thought maybe someone might have an idea how to do this in this forum. By the way is it okay to post the same question in two forums? Anyway here my question: All I need is to email one record from my form.  "InvoiceN" is my only unique qualifier on each record.  My database name...

Thanks for the help, unfortunately I need to send just one record and this includes them all. This database could potentially end up being quite large. So, if I could get it to send just one record, probably in html format, then it won't include everything. Thanks, Hal S.

All I need is to email one record from my database. "InvoiceN" is my only unique qualifier on each record. My database name is "FulfillmentOrderDatabase", my form name is "FulfillmentOrderInterface" and my report name is "rptPrintRecord". It would be...

Correction I mean Email. I need to Email a record not print one.

I've searched for a while now and found a few helpful threads, but unfortunately I'm quite new at Access and Visual Basic, so I'm having a problem plugging in the correct values into code. The thread below is almost exactly what I need minus the multiple fields...