MS access filter using combobox to display calculated fields

[aditya141990]

My access skills are basic, i am still trying to learn access and hence i have arrived to a specific task which i am trying to figure out and would need all your help.
I have The following fields in which the data is received on a monthly basis:

1.MM-YY
2.Assembly level problem of vehicle
3.Part level problem of vehicle
4.Vehicle Model
5.Score of each part level problem
6.country.


Note- Assembly level problems are fixed for all vehicles and they will repeat every month.

Requirement:
A form with combo box with the following filtering criteria
1.First drop down - Country.
2.Second drop down - Vehicle model
3.Third drop down - MM-YY.
After selecting all three. i would like to display this into a split form.
1. Assembly level problem of selected vehicle.
2. Sum of scores of part level problem - that come under each vehicle assembly

Please let me know if this is possible to do in access

[ranman256]

Instead of writing all this vb code ,(which you probably don't know)
Wouldn't it be easier to just right click on the field and apply your filter.
right click on country ,enter Spain, and it filters.
then Right click on model,enter Fiat, etc...no programming.