D
Darknezraven
Ok I have been tasked with doing this and am very new to Access. So if I dont
understand please bear with me. Here is what i am trying to do. I want to use
a form with a combo box or list to display only that information selected on
a report. I have the combo box and command button created. Command button
will open the report but is not filtering what i select in the combo box.
Please Help. Is prob a simple answer. Here is that i have so far.
Option Compare Database
Option Explicit
Private Sub cmdOpenReport_Click()
On Error GoTo Err_cmdOpenReport_Click
Dim stDocName As String
stDocName = "rptContacts"
DoCmd.OpenReport stDocName, acPreview
Exit_cmdOpenReport_Click:
Exit Sub
Err_cmdOpenReport_Click:
MsgBox Err.Description
Resume Exit_cmdOpenReport_Click
End Sub
understand please bear with me. Here is what i am trying to do. I want to use
a form with a combo box or list to display only that information selected on
a report. I have the combo box and command button created. Command button
will open the report but is not filtering what i select in the combo box.
Please Help. Is prob a simple answer. Here is that i have so far.
Option Compare Database
Option Explicit
Private Sub cmdOpenReport_Click()
On Error GoTo Err_cmdOpenReport_Click
Dim stDocName As String
stDocName = "rptContacts"
DoCmd.OpenReport stDocName, acPreview
Exit_cmdOpenReport_Click:
Exit Sub
Err_cmdOpenReport_Click:
MsgBox Err.Description
Resume Exit_cmdOpenReport_Click
End Sub