Thanks guys,
It worked beautifully.
One more thing while I have you here...
How can I get the fields to format within this code? For example, when I call their values from the recordset a field like AMOUNT is 1000000 wheras I would like it to show up as $1,000,000.
Is this 'on the fly'...