Fetch Query Results

[d0djem]

hi everyone,

i've got a problem which has been driving me nuts...

i'm writing SQL in VBa and i want to SELECT a row from a table and fetch the results in an array.

Dim Query As String
Query = "SELECT * FROM [CD Copies] WHERE [AccessionID] = [Forms]![Return-Loan]![edtAccessionID]"
DoCmd.RunSQL Query

How do i fetch the results of this to use later in the code e.g. below in PHP

<?php
$query = mysql_query("SELECT * FROM `CD Copies` WHERE `AccessionID` = $edtAccessionID");
$row = mysql_fetch array($query);
if date(d M Y) > $row['date due'] 
   print "CD Overdue.";
?>

which'll would maybe look something like this in VBa:

if date() > row.[date due] then
 msgbox("CD Overdue")
end if

thanks in advance
Mike