Need Help ... make value appear according to conditions

[tarek_ta2ta2]

i have 4 Combo boxes

1- make
2- model
3- transmission
4- year

the user choose values from this combo boxes
EX. Toyota - corrola - Manual - 2005

so what i wanna do is make a button when the user push it after selecting all values compare this values to values stores in another table so if the values is matched make the last cell value in this table appear ( which will be the price)

is it possible or i just dream.....

 

[John Big Booty]

What you could do is use the values, the combos, as criteria in a query against your table. If there is a match you show the price, otherwise you show a message indicating no result (match).

 

[tarek_ta2ta2]

ok .... can you gice me a clue how to do it

 

[John Big Booty]

In the criteria of the fields you are searching put the following.

Forms!YourFrmName!ComboName

 

[tarek_ta2ta2]

NOt Get It

can anyone please descirbe it in simple way to me

how to do it in steps



sorry but i'm new to access and need this urgent