Hi Experts
I have two boxes and using them separate for opening the report.
Now I want to open the report to select from the twice boxes but I am unable to understand how to select them.
The code is given under:
If Me.Category_Case_Criminal.ItemsSelected.Count = 0 Then
MsgBox "Please Select atleast One Item"
Exit Sub
End If
'add selected values to string
Set ctl = Me.Category_Case_Criminal
For Each varItem In ctl.ItemsSelected
'strWhere = strWhere & ctl.ItemData(varItem) & ","
strWhere = strWhere & "'" & ctl.ItemData(varItem) & "',"
Next varItem
'trim trailing comma
strWhere = Left(strWhere, Len(strWhere) - 1)
If Me.Category_Case_Criminal.ItemsSelected.Count = 0 Then
There is problem I want to add two boxes here: the second is under:
If Me.Category_Case_Civil.ItemsSelected.Count = 0 Then
If I code it as: If Me.Category_Case_Criminal.ItemsSelected.Count = 0 & If Me.Category_Case_Civil.ItemsSelected.Count = 0 Then its give error
I don't understand what to write instead of Then so it may select the twice boxes at once
How can I select from two boxes so it may open the report containing twice result.
The report is already generated by innerjoin query:
The Screen short is under: