Exporting parameter queries results to excel - is this normal

[Guest]

I am running a parameter query using [Enter Part Number]. It asks me for part
number before it actually runs the query. I enter the part number in the
parameter box and get the results. I go to "file" > Export, change the file
type to excel 97-200(*.xls), enter a file name and hit export all. It then
pops back to the access data sheet and asks for the part number again in the
parameter box . If I dont enter the information( hit return) I get no excel
file. If I do enter it seems to work.

This only seems to happen with parameter queries
Thanks for any assistance

 

[John Spencer (MVP)]

Yes, it's normal.

When you do the export, the query is started all over again. Which does make
sense, since Access has no real way of telling how long ago you ran the
presently open query and in theory, the data could have been changed, or you
might actually want a different part number.