OK I got it to work!Create the query in Access, to test, then simply grab the SQL and use that in your VBA routine.
Which part of my example did you not follow, specifically?
Now I need to be able to query more than one field (Both in the key for the lookup and fields to return).
Field A, B, C, D
10, 1, 100, 1000
10, 2, 999, 999
20, 1, 50, 40
20, 2, 25, 25
Input Field A and Field B.
Output Field C and Field D in the record where Field A = Input A and Field B = Input B.