DLookup with two criteria (integer variable)

[jasmin_m]

Dim x As Integer
Dim y As Integer

x = 1
y = 2

a = DLookup("[field]", "table", _
"[field2] = " & x And "[field3] = " & y)

In above example criteia is incorect,
how can I write it correct.

 

[pbaldy]

Only your variables should be outside the quotes. You have the And outside them. Check the example at the bottom here, even though it uses mixed data types:

http://www.mvps.org/access/general/gen0018.htm

 

[RuralGuy]

Try:
a = DLookup("[field]", "table", "[field2] = " & x & " And [field3] = " & y)
...the And needed to be in the string.

 

[RuralGuy]

Darn...you guys in Nevada type too fast.

 

[pbaldy]

It's the higher oxygen content down here at 5,000'.

 

[jasmin_m]

Thanks guys

 

[RuralGuy]

It's the higher oxygen content down here at 5,000'.

And here I thought that was all just hot air!!

 

[jasmin_m]

Is it posible to use DLookup with two table(domain)

example;

a = DLookup("[field]", "table1 & table2", "[field2] = " & x & " And [field3] = " & y)

 

[pbaldy]

To my knowledge, no. If you can create a query that joins the two tables appropriately, you could use the DLookup() against that.