Link between query and form object value's

[nkamp]

Hello,

I have asked this question an earlier time but I didn't get the right answer. I have made a workaround but on the end it's not enough.

I'm starting the code beneath from the form:

Application.ExportXML _
    ObjectType:=acExportQuery, _
    DataSource:="qryXMLexport", _
    DataTarget:="c:\xmltest"

And here is the query:

ELECT *
FROM dbo_rpt_project, dbo_rpt_job
WHERE dbo_rpt_job.sar_number=34380 
And dbo_rpt_job.project_number=dbo_rpt_project.project_number
And dbo_rpt_job.external_resourcing=forms!frmLaraClientRequests!chkSubcontractors;

This is working fine, except when the query is running an input box window is popping up, asking the value of the form object "forms!frmLaraClientRequests!chkSubcontractors"

Why? The form is open/active. I'm starting all these from the form.

Normally query's are made for users who can make choices by selection fields on the form and run the query by this selection criteria OR NOT?
Is there property at query that you can say where this query depends on?

Is it due to Application.exportXML?

Can somebody give me explanation why is this not working.

Thanks in advance,

Nico.

By the way, I can't use solution with query's and temp tables because some fields have more than 255 char.