As clearly as I can explain it, here’s the problem:
Version: Access 2002
I have a form based on a query. I have several, unbound combo-boxes used to navigate to certain records in the query. Each builds it’s drop-down list from the choice of the one before, using a QBE on the Row Source property of the cbo.
For each query used to build the drop-down, I hide the numerical key field and display the text value. Using the hidden key fields selected as parameters for the combos, I am able to filter down to a subset of records without problems.
When I get to the last one, and then click a Close button I have put on the form, I get the following message:
“Enter Parameter Value” and then the name of the 2nd to last cbo of the sequence.
In an attempt to solve this, I have stripped out all code (except for the docmd.Close on the button) and isolated the problem to the actual controls. The message does not occur if I use the X button to close the form.
I recognize (I think) that the query behind the last combo box is looking for the value of the previous combo box, but am unable to figure out why it doesn’t “see” the choice made there. Each query produces the desired results in their drop-downs. I also recognize there are probably things that happen, code-wise, behind the X-button that I am not providing for with my simple: doCmd.Close, “Name of Form”
I apologize in advance for the “newbiness” of this questions. I am so brain-dead from trying to figure this out that if you told me I’d spelled my own name wrong, I’d be grateful.
I hope I have sufficiently explained, and I will be glad to elucidate if I have been unclear.
Much thanks to all in advance.
Tru
Version: Access 2002
I have a form based on a query. I have several, unbound combo-boxes used to navigate to certain records in the query. Each builds it’s drop-down list from the choice of the one before, using a QBE on the Row Source property of the cbo.
For each query used to build the drop-down, I hide the numerical key field and display the text value. Using the hidden key fields selected as parameters for the combos, I am able to filter down to a subset of records without problems.
When I get to the last one, and then click a Close button I have put on the form, I get the following message:
“Enter Parameter Value” and then the name of the 2nd to last cbo of the sequence.
In an attempt to solve this, I have stripped out all code (except for the docmd.Close on the button) and isolated the problem to the actual controls. The message does not occur if I use the X button to close the form.
I recognize (I think) that the query behind the last combo box is looking for the value of the previous combo box, but am unable to figure out why it doesn’t “see” the choice made there. Each query produces the desired results in their drop-downs. I also recognize there are probably things that happen, code-wise, behind the X-button that I am not providing for with my simple: doCmd.Close, “Name of Form”
I apologize in advance for the “newbiness” of this questions. I am so brain-dead from trying to figure this out that if you told me I’d spelled my own name wrong, I’d be grateful.
I hope I have sufficiently explained, and I will be glad to elucidate if I have been unclear.
Much thanks to all in advance.
Tru