Parameter Promp After Form Closing

[jv]

I have a form named frmCustomerWithJobs with a combo box with the
following rowsource:

SELECT ContactID, ContactName, ContactType, Phone, ContactTitle FROM
Contacts WHERE CustomerID=[Forms]![frmCustomerWithJobs]![CustomerID]

The combo box works OK. However, after I close this form, a parameter
box would appear asking me for the
[Forms]![frmCustomerWithJobs]![CustomerID] parameter.

I can't figure out why it is doing this. I've try stepping through it
in break mode. However, the behavior does not occur in break mode.
Please help.

Thanks.

Julie Vazquez

[Br]

jv wrote:

I have a form named frmCustomerWithJobs with a combo box with the
following rowsource:

SELECT ContactID, ContactName, ContactType, Phone, ContactTitle FROM
Contacts WHERE CustomerID=[Forms]![frmCustomerWithJobs]![CustomerID]

The combo box works OK. However, after I close this form, a parameter
box would appear asking me for the
[Forms]![frmCustomerWithJobs]![CustomerID] parameter.

I can't figure out why it is doing this. I've try stepping through it
in break mode. However, the behavior does not occur in break mode.
Please help.

Thanks.

Julie Vazquez

Do you have any code on one of the events triggered when the form is closed?
--
regards,

Br@dley

[RoyVidar]

jv wrote in message
<11**********************@i39g2000cwa.googlegroups .com> :

I have a form named frmCustomerWithJobs with a combo box with the
following rowsource:

SELECT ContactID, ContactName, ContactType, Phone, ContactTitle FROM
Contacts WHERE CustomerID=[Forms]![frmCustomerWithJobs]![CustomerID]

The combo box works OK. However, after I close this form, a parameter
box would appear asking me for the
[Forms]![frmCustomerWithJobs]![CustomerID] parameter.

I can't figure out why it is doing this. I've try stepping through it
in break mode. However, the behavior does not occur in break mode.
Please help.

Thanks.

Julie Vazquez

I don't know, but could it be this?
http://support.microsoft.com/?id=811860

--
Roy-Vidar

[jv]

Thank you for the link. I think you identified the problem. I worked
around it by populating the combo box using VBA:

BillingContactID.RowSource = "SELECT ContactID, ContactName,
ContactType, Phone, ContactTitle FROM Contacts WHERE CustomerID='" &
[CustomerID] & "'"