Too Few Parameters. Expected 1. error when exporting

[sdelacruz8]

Hi,

I'm trying to export a simple query to a text file. However, it gives me a "Too Few Parameters. Expected 1" error message. The query works fine when exporting to other formats, ie, Excel. I have a date parameter that pulls from a form. I'm using Access 2002. Below is my query:

SELECT Main_tbl.Sub_id, Max(Main_tbl.Group_ID) AS MaxOfGroup_ID
FROM Main_tbl
WHERE (((Main_tbl.Date)<[Forms]![Main_Form]![EndDateTxt]))
GROUP BY Main_tbl.Sub_id;

Thanks!

 

[PHV]

Is Main_Form open when you try to export the query ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[sdelacruz8]

Yes, the Main_Form is open and the EndDateTxt is populated with a date. The query works fine when I run it. The only time i get that error msg is when I export to a Text file.