Asking for parameters..unexpectedly

[lynxbci]

Hi,
I have a query which uses a table and 2 parameters from a form. The form is loaded/open and the 2 fields have data in them.

However, when I run the query it ask for both parameters.... why would this be?

Here is sql for my query and both fields "MCode" and "Current Rev" DEFINITELY have data in them

SELECT tbl_bomlis2.[Material code], tbl_bomlis2.[Nest efficency], tbl_bomlis2.[Cutting (sec)], tbl_bomlis2.[Nest Length (mm)], tbl_bomlis2.MCode, tbl_bomlis2.Revision INTO tbl_minorUpdate
FROM tbl_bomlis2
WHERE (((tbl_bomlis2.MCode)=[Forms]![frm_Update]![MCode]) AND ((tbl_bomlis2.Revision)=[Forms]![frm_Update]![Current rev]));

 

[namliam]

do you open this query yourself or run it from vba?

 

[lynxbci]

The query runs from VBA but I tried opening it manually and both ask me for parameters, even with [forms]![frm_update] open and all fields filled...

 

[lynxbci]

I have just re created the form from scratch with al the same fields and records identical and now it works! Must have just been a glitch... I will continue to check it, but there was no reason I could work out for the error.