sintax error

[irade92]

Hi
Why I get this message..please see pic1 and pic2

Thanks in advance

 

[Gasman]

Query is using/requires a parameter?

Please post the query SQL within code tags.

 

[Ranman256]

something in the query wants a parameter filled in.
either a form reference,
or instant param field: [param enter here]
or a misspelled fieldname

if the query DOES need a param filled, then you cant use your structure,instead use a querydef and fill in the param there....

Set qdf = currentDb.QueryDefs("qsMyQuery")
qdf.Parameters(0) = "6/1/03"
qdf.Parameters(1) = "11/1/03

set rst = qdf.openrecordset

 

[The_Doc_Man]

Also, it is possible that due to substitution or other unusual syntax, you might have a function that demanded a parameter but somehow you didn't supply one even though you might have thought that you did.

 

[irade92]

Query is using/requires a parameter?

Please post the query SQL within code tags.

My intention was to count unmatched articles, so I solved this in another way..in a table are all articles and in a form are only match so a simple math solved this ..how many unmatched articles are..Dcount in a table minus count in a form..simple isn't it
Thanks for your answer