Drop list word Filtering

[matrixsoul]

Hi Every one,
i'm very new in access, i get shocked how deep is it,
here is where i am
i made a table to store a daily activities under 7 categories like food, transportation, etc.
i made a split form where upper part has the form to make my input and lower form has all records as sheet view,
i need to create a drop list contains all Categories and when i press any cat. it should filter all records in down part accordingly..
i know it is possible in VBA or Macro.. But i spent 4 days trying to do it with no result

Thanks for helping

 

[namliam]

Have a search on forum for "search form" you will find plenty of working examples, see if you can work it from there.

 

[matrixsoul]

Thanks a lot, actually i successes to make what i wanted in VBA code as follow

Private Sub cboShowCat_AfterUpdate()
If IsNull(Me.cboShowCat) Then
Me.FilterOn = False
Else
Me.Filter = "Category = """ & Me.cboShowCat & """"
Me.FilterOn = True
End If
End Sub
Private Sub cboShowstatus_AfterUpdate()
If IsNull(Me.cboShowstatus) Then
Me.FilterOn = False
Else
Me.Filter = "status = """ & Me.cboShowstatus & """"
Me.FilterOn = True
End If
End Sub

but i think this is still at beginner level cause it doesn’t reach what i want such as
- adding show all choose
- using two criteria to filter jointly

but I’m still trying

Thanks everyone

 

[highandwild]

To use multiple criteria just combine the filters from the two combo boxes.

If you had a listbox the use could select multiple criteria.

I take it that you need to have an "All" option?

You can add an "All" option to the combo box query by using a union query or just have an "All" command button. The latter is easier but I prefer the formar way but slightly more work and maybe trickier.

Just shout for more help if you need it.

 

[namliam]

Have a search on forum for "search form" you will find plenty of working examples, see if you can work it from there.

There are some good samples on forum