What Is Wrong In This Querie?

Hi everyone,

Now, I'm totally lost!
When I create a query with the Query Design view in Access with this SQL query:


SELECT T_Cryzout_Disponibles.LCLCL_Disponibles_Total, T_Cryzout_Disponibles.DateEmission, T_Cryzout_Disponibles.NomReceveur, T_Cryzout_Disponibles.Ordre
FROM T_Cryzout_Disponibles
WHERE (((T_Cryzout_Disponibles.LCLCL_Disponibles_Total) Like 'C*') AND ((T_Cryzout_Disponibles.DateEmission) Is Null) AND ((T_Cryzout_Disponibles.NomReceveur) Is Null Or (T_Cryzout_Disponibles.NomReceveur)=''))
ORDER BY T_Cryzout_Disponibles.Ordre;


everything is good, I get what I'm suppose to get. But When I'm doing it in VBA with this code:


RExtraction.Open "SELECT TOP " & NbrLCLCL & " LCLCL_Disponibles_Total FROM " & QuelleTable & " WHERE (((LCLCL_Disponibles_Total) like 'C*') AND ((DateEmission) Is Null) AND ((NomReceveur) Is Null)) ORDER BY Ordre", ConnectionBD, adOpenStatic, adLockOptimistic

RExtraction.MoveFirst


It gives me an error that says:
BOF or EOF is egal to True.

And I really don't know what is wrong with this. It is pretty much the same as the query I entered in the Query Design.

I'm really confuse.

Thank you in advance for your help!!!