I have a table [HIP-MSP-Filter] with the following text fields
Status
group_type
query_hits
PLATFORM
Group_No_7
Group_No_3
I need to be able have a form which uses combo boxes as required and optional filter criteria and then displays the results in an updatable subform.
[Forms]![frm_update_&_review]![cbo_Status] Required Filter
[Forms]![frm_update_&_review]![ cbo_group_type] Optional Filter, cbo needs to be grouped
[Forms]![frm_update_&_review]![ cbo_query_hits] Optional Filter, cbo needs to be grouped
[Forms]![frm_update_&_review]![cbo_ PLATFORM] Optional Filter, cbo needs to be grouped
[Forms]![frm_update_&_review]![cbo_Group_No_7] Optional Filter, cbo needs to be grouped
[Forms]![frm_update_&_review]![cbo_Group_No_3] Optional Filter, cbo needs to be grouped
I have already tried the below which did nothing
Private Sub cbo_group_type_AfterUpdate()
If IsNull(Me.cbo_group_type) Then
Me.FilterOn = False
Else
Me.Filter = "group_type = """ & Me.cbo_group_type & """"
Me.FilterOn = True
End If
End Sub
Any help is greatly appreciated.