P
PHisaw
Hi,
I use the following code to open and print reports in the AfterUpdate event.
Works well, now users want to be able to use same report with any entry for
Smith in CustomerName field. Example: Smith, A or Smith, John. How do I
use a wildcard in code to pull all entries for Smith*?
If Me.Parent!CustomerName = "Smith" Then
DoCmd.OpenReport "SmithJobs"
Thanks in advance for any help,
Pam
I use the following code to open and print reports in the AfterUpdate event.
Works well, now users want to be able to use same report with any entry for
Smith in CustomerName field. Example: Smith, A or Smith, John. How do I
use a wildcard in code to pull all entries for Smith*?
If Me.Parent!CustomerName = "Smith" Then
DoCmd.OpenReport "SmithJobs"
Thanks in advance for any help,
Pam