1 - I created search criteria based in one input ( contract status “ Combo box”)
I need to add to it another criteria (Vendor Number “ text Box” ) ( the number will be entered manually )
This is the Code in the Search button.
Expand|Select|Wrap|Line Numbers
- Dim strCriteria As String
- Dim strReportName As String
- strCriteria = "[Contract Status]='" & Me![Contract Status] & "'"
- strReportName = "PMCONTRACTS"
- If [Contract Status] = "Select" Then
- DoCmd.OpenReport strReportName, acViewReport
- Else
- DoCmd.OpenReport strReportName, acViewReport, , strCriteria
- End If
- ' Reset Form
- [Contract Status] = "Select"
Please find the attached .
PS : Regarding number (2) question how to Export report to Excel.
Thank you I found the answer in this link http://bytes.com/topic/access/answer...a-output-excel