[ACCESS 2003] Select return error

[wilow]

Hi,

I have a sql code:

stan = CurrentProject.Connection.Execute([COLOR=Red]"SELECT quantity FROM Magazine WHERE nr_ref= " & [Forms]![Main]![nr_ref_wyst] & ";"[/COLOR]).Collect(0)

When the red select return any value, then varriable 'stan' is correct. But when the red select has no value to return then raises error. I don't want error. When select returns an error then I want to have a value of 0

 

[pr2-eugin]

wilow, What error does it throw up?

 

[wilow]

Run-time error '3021' 
Function BOF or EOF return true value or current record was removed. Requested operation requires a current record

>>This error has been translated by me from Polish to English :-D