I have a send object command that send a report. The problem I am having is that the rptCSM report loops to the bound table? How I know this is when I go to the email the report will have the same amount of pages as there are records to the rptCSM bound Table. There should only be one page to the rptCSM report.
I have this logic and I think I am filtering correctly:
'Check if in the SCGTable
Set rsSCGTable = New ADODB.Recordset
sSQLSCGTable = "Select * from SCGTable where SCGNumber = '" & TxtSCGID & "'"
rsSCGTable.Open sSQLSCGTable, CurrentProject.Connection
If rsSCGTable.EOF Then
DoCmd.OpenReport "RptCSM", , , "SCGNumber = " & "'" & TxtSCGID & "'", acHidden
DoCmd.SendObject acSendReport, "RptCSM", "Rich Text Format",
DoCmd.Close acReport, "RptCSM"
As you can see this is in ADO Verison 6.0
Also when I try this there is some small sized menus that come up and I don't want to see them?