Finding a record by using 2 combo box!

[emreut]

I used the wizard to make my form go to a record by using the content of a combo box. But I need the form to go to a specific record depending on the values from two seperate combo box because none of the two combo box create a uniqe value.
I changed the code to insert one more arguement for the FindFirst method but I couldn't get it to work. It does not accept AND to enter two criteria.

Any ideas?

Thanks in Advance!

 

[Jack Cowley]

FindFirst will accept AND to find two criteria. You must have had a syntax error in your criteria... Give it another try and if it doesn't work post your code so someone can find your error.

HTH,
Jack