Send a single form record from among many, electronically

[WinDancer]

One of my applications contains a large table that houses all of the records for identical surveys for many customers. That data is collected via a form.

The users needed a way to select a single form to print.

This code accomplished that and still works fine.

******************
DoCmd.Echo False
DoCmd.SetWarnings False
Forms!frmtabsurvey!Page1.SetFocus
DoCmd.PrintOut
Forms!frmtabsurvey!Page2.SetFocus
DoCmd.PrintOut
Forms!frmtabsurvey!Page3.SetFocus
DoCmd.PrintOut
Forms!frmtabsurvey!Page4.SetFocus
DoCmd.PrintOut

DoCmd.Echo True
DoCmd.SetWarnings True
*********************

My users have now come back and asked if there is a way to electronically send a specific survey to a specific customer.

How would you do this?
Thought I would ask before I get myself all crazy, this time.

Thanks,
Dave

 

[boblarson]

Dave:

I would highly suggest you create a report for this task.