I have created reports which needs to be filter out based on user selected value from the combo box.
Detail : I have form with option group and combo box... when user selects one of the option combo is visible which allows user to pick value and then click on "cmdPreview" to preview reports. I have wrote following code but nothing happens when user clicks on the "cmdPreivew"
Please tell me what's wrong here.
Private Sub cmdPreviewReports_Click()
On Error GoTo printerror
Dim strReport As String
Dim strField As String
Dim strWhere As String
I also need to create reports that will tell me number of mother screened, total # of Mother enrolled and total # of infant enrolled...by week....month or yearly.....Any suggestion or example how to do this ?