dlookup columns matching

[petertje]

I came across this problem today and i haven't found anything about this on the microsoft page or on this forum .

This is the table:

car_number //////car_total

11///// 7
11///// 6
11//// / 5
12 ///// 4
12///// 5

Function:



DLookup(expr, domein [, criteria] )

I have two textboxes in a form the first one is the one you can put in your car_number and in the other one you can put in your car_total

so when somebody types in his car_number and his car_total I first whant to filter with car_number and then match what is filled into the textbox car_total with what is in the database.

At the moment I' m using this.

" cartotal = " & me.cartotal"

But this value gives me all the values of all the car_total that has been filled into the textbox, but I whant the one that matches car_total and car_numbers


so in this case:

If textbox car_number is filled in with 11
and the textbox car_total is filled with 5

Then I whant it to return 5 and not twice 5

Thanks in advance!

-Petertje

[June7]

You want to enter two values into UNBOUND controls and use them as filter criteria to retrieve record?

A parameterized query is one way:

SELECT * FROM table WHERE car_number = Forms!formname!tbxCarNum AND car_total = Forms!formname!tbxCarTot;

That query can be RecordSource for a form or report.