Error when closing form

  • Thread starter Thread starter jenni_p
  • Start date Start date
J

jenni_p

Hello -
I have a form setup that contains 2 combo boxes, 1 button
to open a different form and 1 button to close the form.

The 2 combo boxes are as follows
cmb_pub
pub_id (pk)
publication

cmb_issue
prod_req_id
IssueDate
Pub_id criteria= [Forms]![frm_OUpubSelect]![cmb_pub]

In the after update event of the cmb_pub I have:
=cmb_issue.Requery

The idea of this form is to find the appropriate record
to work on and then open up the form with the
corresponding data.

The problem:
A user selects the first combo box, then the second, then
clicks the button to open form2. When they are finished,
they close form2 and then would click on the button to
close form1 which is a simple DoCmd.close.
When you try to close this form, I get the following...
[Forms]![frm_OUpubSelect]![cmb_pub]
it is looking for a pub_id from the criteria in my second
combo box.

This stumped our resident expert here and it is driving
me batty, any ideas??

Thank you,
Jenni
 
Hi Jenni,

Are the following conditions true for you?

- Windows XP (Home and Pro)

- Your form has a combo or listbox that has a reference to a control on the
same form in it's criteria

- The form is maximized

- You close the form via a command button. The problem doesn't occur when
you use the Default close button (X).

If you have these same elements in your form I would suspect you are
experiencing the known bug in the following KB Article:

BUG: Enter Parameter Value Dialog Box Appears While Trying to Close a Form
Window
http://support.microsoft.com/?id=811860
 
WOW! Its like you were reading my mind.
That is exactly the problem and I never would've thought
it was bug.
Thank you, Thank you!
Jenni
-----Original Message-----
Hi Jenni,

Are the following conditions true for you?

- Windows XP (Home and Pro)

- Your form has a combo or listbox that has a reference to a control on the
same form in it's criteria

- The form is maximized

- You close the form via a command button. The problem doesn't occur when
you use the Default close button (X).

If you have these same elements in your form I would suspect you are
experiencing the known bug in the following KB Article:

BUG: Enter Parameter Value Dialog Box Appears While Trying to Close a Form
Window
http://support.microsoft.com/?id=811860

--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.


jenni_p said:
Hello -
I have a form setup that contains 2 combo boxes, 1 button
to open a different form and 1 button to close the form.

The 2 combo boxes are as follows
cmb_pub
pub_id (pk)
publication

cmb_issue
prod_req_id
IssueDate
Pub_id criteria= [Forms]![frm_OUpubSelect]![cmb_pub]

In the after update event of the cmb_pub I have:
=cmb_issue.Requery

The idea of this form is to find the appropriate record
to work on and then open up the form with the
corresponding data.

The problem:
A user selects the first combo box, then the second, then
clicks the button to open form2. When they are finished,
they close form2 and then would click on the button to
close form1 which is a simple DoCmd.close.
When you try to close this form, I get the following...
[Forms]![frm_OUpubSelect]![cmb_pub]
it is looking for a pub_id from the criteria in my second
combo box.

This stumped our resident expert here and it is driving
me batty, any ideas??

Thank you,
Jenni
Click to expand...


.
Click to expand...
 
Glad to help!

I have to admit that I went through a lot of pain when my company initially
started implementing WinXP. My main application started kicking out these
prompts and it was driving me nuts. I spent a fair amount of time isolating
the conditions that created the problem and finally MS PSS was able to
duplicatate it and document it.

--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.


jenni_p said:
WOW! Its like you were reading my mind.
That is exactly the problem and I never would've thought
it was bug.
Thank you, Thank you!
Jenni
-----Original Message-----
Hi Jenni,

Are the following conditions true for you?

- Windows XP (Home and Pro)

- Your form has a combo or listbox that has a reference to a control
on the same form in it's criteria

- The form is maximized

- You close the form via a command button. The problem doesn't occur
when you use the Default close button (X).

If you have these same elements in your form I would suspect you are
experiencing the known bug in the following KB Article:

BUG: Enter Parameter Value Dialog Box Appears While Trying to Close
a Form Window
http://support.microsoft.com/?id=811860

--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.


jenni_p said:
Hello -
I have a form setup that contains 2 combo boxes, 1 button
to open a different form and 1 button to close the form.

The 2 combo boxes are as follows
cmb_pub
pub_id (pk)
publication

cmb_issue
prod_req_id
IssueDate
Pub_id criteria= [Forms]![frm_OUpubSelect]![cmb_pub]

In the after update event of the cmb_pub I have:
=cmb_issue.Requery

The idea of this form is to find the appropriate record
to work on and then open up the form with the
corresponding data.

The problem:
A user selects the first combo box, then the second, then
clicks the button to open form2. When they are finished,
they close form2 and then would click on the button to
close form1 which is a simple DoCmd.close.
When you try to close this form, I get the following...
[Forms]![frm_OUpubSelect]![cmb_pub]
it is looking for a pub_id from the criteria in my second
combo box.

This stumped our resident expert here and it is driving
me batty, any ideas??

Thank you,
Jenni
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top