By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,223 Members | 1,608 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,223 IT Pros & Developers. It's quick & easy.

Parameter Promp After Form Closing

P: n/a
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

Mar 7 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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
Mar 7 '06 #2

P: n/a
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
Mar 8 '06 #3

P: n/a
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] & "'"

Mar 10 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.