Sub form works great for this. Now next problem is that I have a report and am trying to limit the report based upon the record in the sub form. I am doing this via a command button that runs a query with the sub form field as the limiting criteria. When doing this I am getting an error that is prompting for the value in the sub form. Belos is the code for the command button.
Form_filing is the main form and Frm_Equip is the sub form and ID is what
I want the report to be limited to.
Private Sub Frm_Send_Click()
Dim strSQL As String
On Error GoTo Err_Frm_Send_Click
strSQL = "Update TD_Paperwork SET Submit_Date = Now(), Filed = True WHERE ID = [Forms]![FORM_FILING_NEW]![FRM_EQUIP].[Form]![ID] ;"
'strSQL = "UPDATE TD_Paperwork
DoCmd.SetWarnings False
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
DoCmd.RunSQL strSQL
DoCmd.SendObject acSendReport, "RPT_Filing_1", acFormatRTF, "to", , , "Filing",
DoCmd.SetWarnings True
Exit_Frm_Send_Click:
Exit Sub
Err_Frm_Send_Click:
MsgBox Err.Description
Resume Exit_Frm_Send_Click
End Sub
Thanks in Advance!