Parameter Promp After Form Closing

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

re: Parameter Promp After Form Closing

jv wrote:[color=blue]
> 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[/color]

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

Br@dley

re: Parameter Promp After Form Closing

jv wrote in message
<1141758465.530959.226150@i39g2000cwa.googlegroups .com> :[color=blue]
> 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[/color]

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

--
Roy-Vidar

re: Parameter Promp After Form Closing

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] & "'"