Hello!
I have a form (called, let's say, MyFormName) that has 3 combo boxes on it. The user selects a value from a list in the first combo box, and then I use this code -
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
></o>
<o></o>
- and a SELECT statement to have the second combo box show a list of values based on what was in the first combo box. Then the user picks a value from the second box, and similar code makes the third combo box show values based on what the second one has.
<o></o>
This form works perfectly on its own as a pop-up, but when I put it in another form as a subform the requery does not work right. After making a selection in the first combo box, Access asks for a value ("Enter a Parameter Value: Forms!MyFormName!FirstComboBox") for the first box when it tries to run the code above.
<o></o>
Assuming the description of my problem makes sense, does anyone know why this is happening? And how I can fix it? I was thinking that changing
to
would work, but it did not.
I can find lots of solutions for requerying the subform when something on the Parent form changes and vice versa, but nothing about requerying a field on the subform when something on the subform changes.
<o></o>
Thanks for the help!
I have a form (called, let's say, MyFormName) that has 3 combo boxes on it. The user selects a value from a list in the first combo box, and then I use this code -
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o></o>
Code:
Me.SecondComboBox.Requery- and a SELECT statement to have the second combo box show a list of values based on what was in the first combo box. Then the user picks a value from the second box, and similar code makes the third combo box show values based on what the second one has.
<o
></o>This form works perfectly on its own as a pop-up, but when I put it in another form as a subform the requery does not work right. After making a selection in the first combo box, Access asks for a value ("Enter a Parameter Value: Forms!MyFormName!FirstComboBox") for the first box when it tries to run the code above.
<o
></o>Assuming the description of my problem makes sense, does anyone know why this is happening? And how I can fix it? I was thinking that changing
Code:
Me.SecondComboBox.Requery
Code:
[Forms]![MyFormName].SecondComboBox.RequeryI can find lots of solutions for requerying the subform when something on the Parent form changes and vice versa, but nothing about requerying a field on the subform when something on the subform changes.
<o
></o>Thanks for the help!
