View Results according to value selected in a drop down list

[darwish]

hello

i have the following attached file



I have a table containing list of cars and its year.

also i have a split form. i want in the split form a dropdownlist up having cars name and when i select a car name i want the below table in the split form to be filtered according to the selected value in the combobox.

any help is appreciated.

Thank you

[June7]

Options are:

1. dynamic parameterized query http://www.datapigtechnologies.com/f...tomfilter.html

2. code that sets the Filter property of the form

3. code that sets the RecordSource property of the form

[darwish]

thank you june 7
but what i want not only one record
what i want is that when i choose a car, all cars with same name must appear in a gridview

[June7]

Same principle. Apply whatever filter criteria you want on whichever fields you want.