parameter prompted twice

[Dave Cullen]

I have a query that prompts the user for a parameter. It works fine. But
if I create another query that uses the first as the source, the
parameter input is prompted twice. How can I eliminate that?

Here's the first query, with promped parameter:

SELECT HIDCPS_WORKORDERLABOR.WONUMBER, HIDCPS_WORKORDERLABOR.QTYPASSED
AS [RSM Qty], HIDCPS_WORKORDERLABOR.SPOOLNUMBER1,
HIDCPS_WORKORDERLABOR.SESSIONDATE AS [RSM Date],
HIDCPS_WORKORDERLABOR.RSM_NUMBER
FROM HIDCPS_WORKORDERLABOR
WHERE (((HIDCPS_WORKORDERLABOR.SPOOLNUMBER1)=[Enter Spool Number:]));

And the second:

SELECT DISTINCT [Spool Number Query].SPOOLNUMBER1 AS [Spool No],
HIDCPS_WORKORDERLABOR.WONUMBER, HIDCPS_WORKORDERLABOR.OPERATION,
CDate([SESSIONDATE]) AS [Strip Test Date],
HIDCPS_WORKORDERLABOR.QTYPASSED, HIDCPS_WORKORDERLABOR.QTYREJECTED,
Int(([QTYPASSED]/[Good_Plus_Bad])*100) AS [Percent Yield],
[QTYPASSED]+[QTYREJECTED] AS Good_Plus_Bad
FROM [Spool Number Query] INNER JOIN HIDCPS_WORKORDERLABOR ON [Spool
Number Query].WONUMBER = HIDCPS_WORKORDERLABOR.WONUMBER
WHERE (((HIDCPS_WORKORDERLABOR.OPERATION)="Strip Test") AND
(([QTYPASSED]+[QTYREJECTED])>0));

Thanks