Parameter Prompt repost

[janetb]

No one picked up on this so I thought I'd try again. I have a form loaded
from code like: DoCmd.OpenForm "frmWebEvent", whereCondition:="zEID =
[forms]![frmSwitchboard]![lstWebEvent]" All the functionality on the form
works fine. Form opens, has subforms, lists, combo boxes, etc. When I close
the form
using a button (docmd.close), I get a parameter prompt of: Enter parameter
query for forms!frmWebEvent!zEID The field zEID is the key field for just
about everything and is populated correctly.

I have it narrowed down to one list box causing the problem (although there
are two list boxes on the form). Syntax for listbox's rowsource is:
SELECT dbo_zTblEventFee.zTblEventFeeID, dbo_zTblEventFee.zEID, "$" & [rate]
& " " & [rateFrequency] & " " & [rateTypeDesc] AS Fee,
dbo_zTblEventFee.zOtherDesc AS [Other Desc], dbo_zTblEventFee.zOtherAmt AS Amt
FROM dbo_zTblEventFee LEFT JOIN ((dbo_tblRate LEFT JOIN
dbo_xTblRateFrequency ON dbo_tblRate.rateFreqID =
dbo_xTblRateFrequency.rateFreqID) LEFT JOIN dbo_xTblRateType ON
dbo_tblRate.rateTypeID = dbo_xTblRateType.rateTypeID) ON
dbo_zTblEventFee.zrateID = dbo_tblRate.rateID
WHERE (((dbo_zTblEventFee.zEID)=[forms]![frmWebEvent]![zEID]));

Other list box has the pertaining rowsource of:
......WHERE (((dbo_zTblParticipant.zEID)=[forms]![frmWebEvent]![zEID]));

Anybody know what causes the problem and/or how I can get rid of it?