I'm not much help with parameter queries. Never really use them. (As you may have gathered from your prior query about your report and the form.) Therefore, I'm not really clear about what you're trying to accomplish.
But I'll take a guess here. Since you are INNER JOINing, maybe you should put tblDadosIN first....
FROM tblDadosIN INNER JOIN tblFuncionarios ...
Just a guess that tblDadosIN has to know the criteria for each record it's trying to join with tblFuncionarios.
I don't use PARAMETERS since they seem superfluous to me (except that PARAMETERS will validate that user input is Long). You could simply leave off PARAMETERS and get the same result... if you want the user prompted to enter [tblDadosIn]![CodigoNome].
What confuses me about your query is that the WHERE clause is essentially saying, "give me everything in tblDadosIN". That is, except for the fact that you've tried to declare "[tblDadosIN]![CodigoNome]" as a parameter, "tblDadosIN.CodigoName" and "[tblDadosIN]![CodigoNome]" mean the same thing in an Access query. I don't know if the fact that you've declared it as a parameter overrides the functional definition which means, give me the value of the field CodigoName from table tblDadosIN. Perhaps because you have declared it as a PARAMETER, it thinks it has to ask for a value?
Just curious... why do you use PARAMETERS in your queries? If you're building code to use the queries, why not just build the SQL statement and substitute the parameters in the SQL? If you're trying to control the data that displays on a report or form, just set the filter criteria for the report or form. If you're trying to control what displays on a subform or subreport, just use the Master/Child link fields.
I suppose I should learn more about PARAMETERS. Maybe there is a really good use for them. But as I recall, the last time I tried to use them (so many years ago) I gave up in frustration because I kept getting problems similar to those you are having.
Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group