Filter Using Combo Box On Subform

[acarter1]

I have a form which shows firstname, surname and id in the main form and in the subform it shows their leave record, i want to filter my subform by a combo box, i want to filter the value that is on the leave code, these values can be:
Leave CodeLeave DescriptionALAnnualCARCarersCOMCompassionateLIELieuMATMaternityPATPaternitySCKSickSPESpecialSTUStudy

On my subform i want the values shown are leave description and the leave code is hidden but it is still attached. i would like these to filter all the results on the current subform for the current ID, i have tried and tried but still cant get it to work, any help would be appreciated greatly!

 

[acarter1]

I have a form which shows firstname, surname and id in the main form and in the subform it shows their leave record, i want to filter my subform by a combo box, i want to filter the value that is on the leave code, these values can be:
Leave CodeLeave DescriptionALAnnualCARCarersCOMCompassionateLIELieuMATMaternityPATPaternitySCKSickSPESpecialSTUStudy

On my subform i want the values shown are leave description and the leave code is hidden but it is still attached. i would like these to filter all the results on the current subform for the current ID, i have tried and tried but still cant get it to work, any help would be appreciated greatly!

That really didnt make sense at all.
Basically i have a subform showing all the leave entries for each employee, these have a field on called "leave type" these are divided in to different leave types such as, annual leave, study leave, sick leave etc. i would like a combo box which filters each of these on the click event on update etc, so when i click sick leave in value list of the combo box it filters all the sick leave entries on the subform.

my sick leave table is as follows:

date_entered (auto date stamp)
days leave (how many days leave was taken)
leave_id
assignment number (employee id (primary key))
leave_date_from
leave_date_to
extra_details (remarks on entry)

The values that show on my form are:
days_leave
leave_date_from
leave_date_to
extra_details

help would be greatly appreciated!

 

[acarter1]

Anyone know how to do this?