I am searching some thing through dlookup but it is not going to next record , while i am trying while loop till eof

while not rs.eof

rs.movefirst

b= dlookup("[cartons]","dc","[itemcode]='ioo1'")

rs.movenext

wend

by this command its showing value of only first record where item code i001 found , while i0o1 exists 5 times in recordset , i want value of cartons of 5 records where i001

so pls help me

thanks

rupinder

Why not set your recordset equal to a query which takes [itemcode]='i001' as part of its where clause?

Dlookup always returns a single value.

Regards

ADG