Problem with List box parameter when closing a form

[Zukkster]

I've included a list box in my form that has a SQL statement as the Row source. The SQL statement references a text box on the form.

the SQL statement is;

SELECT DISTINCTROW tblCouponDetail.PrintingMCLU, tblCouponDetail.Description, tblCouponDetail.Segment, tblCouponDetail.CouponType
FROM tblCouponDetail
WHERE (((tblCouponDetail.ContractNumber)=[Forms]![frmInputCouponDetail]![txtContractNumber]));

This works fine until I close the form using the statement

DoCmd.Close acForm, "frmInputCouponDetail"

I get a dialogue box asking me for a parameter value for

Forms!frmInputCouponDetail!txtContractNumber

I've looked all over and can't see anything that is causing this. How do I stop it?

Thanks

 

[Norris68]

Set your listbox RowSource to an empty string before closing your form.

 

[Zukkster]

Doh! Slaps hand against forehead

Thanks