MS-Access 2007 query run-time error -

i have ms-query causes problem @ run-time error # 3071 message long, here begining:

the expression typed incorrectly, or complex evaluated.

the query has many columns , functions, , trial , error have isolated offending part of query be:

... , [component.serial])>=val(([forms]![frm_rptfilter_components].[fldautoseq]))  ,  ([component.serial])<=val(([forms]![frm_rptfilter_components].[fldautoseq2]))) 

the name: frm_rptfilter_components correct name of form input comes , name: fldautoseq, fldautoseq2 names of fields on form.

the expression forms... correct , used in other parts of query. spelling not problem.

the column in database "serial" , integer. being compared form field (text field).

i can execute offending part in:

select * component ((     [component.serial])>=val(([forms]![frm_rptfilter_components].[fldautoseq]))      ,      ([component.serial])<=val(([forms]![frm_rptfilter_components].[fldautoseq2]))) 

so, confused. had offending part contained syntax errors, select above should not have worked. however, when removing part, original big query gives error.

my guess when query run subform, fields not passed correctly query , being numeric fields, causes problem.

do see reason getting message?

try this:

and [component.serial]>=[forms]![frm_rptfilter_components].[fldautoseq] ,  [component.serial]<=[forms]![frm_rptfilter_components].[fldautoseq2] 

and specify these 2 parameters long:

[forms]![frm_rptfilter_components].[fldautoseq]  [forms]![frm_rptfilter_components].[fldautoseq2]