SQL Query Problem :(

[squirrelly1]

Ok, I have the following SQL Query in both Access and VB... In access, it pulls two records, just as it should, but in VB when I do a recordset.recordcount, it gives me "-1" and only opens one recordset into my datareport.

SELECT Company.Name, Company.Address, Company.City, 
Company.State, Company.Zip, Company.Telephone, [Units.Number], Units.Price, Units.CustomerNumber, 
Customers.Name, Customers.Address, Customers.City, 
Customers.State, Customers.Zip, Customers.Telephone, 
Customers.Balance, Customers.LastPayment FROM (Company INNER JOIN Units ON Company.Number = Units.Company) INNER 
JOIN Customers ON (Units.CustomerNumber = 
Customers.Number) AND (Company.Number = 
Customers.Company)

Like I said, It will work in Access, but vb doesn't want to do it...
oh, btw... I'm invoking it by DB.Execute

Thanx,
squirrelly1