check that both your recordsets have records in them. According to your code, if rs_issue has no records in it, then the rs_recieving loop will be ignored. If the tables are relatively similiar, I would advise joining them or using UNION. Otherwise, you would have to find a way to make sure that one recordset set keeps looping if you happened to reach the end of the other.
Try this:
Do while (rs_recieving.eof=false) OR (rs_issue.eof=false)
if (rs_recieving.eof = false) then
...
rs_recieving.movenext
end if
if (rs_issue.eof = false) then
...
rs_issue.movenext
end if
Loop
I haven't tested this, so I don't know if this will work.
Hope this helps 
Topic Options
Post Options
Thanks(0)
