T
Theresa
I have a form (answerCode) that displays options in a combo box (ACodes)
depending on the value of another control (Questions). The combo box
requeries when it obtains focus. This works fine.
When I imbed this form as a subform in another form (CreateC) the control
will no longer requery.
I have tried:
using a macro with requery of the control [only works on the original
form (answerCode)
creating an action even when the control has the focus:
[Forms]![CreateC]![answerCode].Form![ACodes].Requery {doesn't requery}
What am I doing wrong? The control shows the answer selections for the first
question and then continues to show the same answer selection regardless of
the question number.
Why does it work so well as a stand alone and falls apart as a subform?
Thanks - I need help!
depending on the value of another control (Questions). The combo box
requeries when it obtains focus. This works fine.
When I imbed this form as a subform in another form (CreateC) the control
will no longer requery.
I have tried:
using a macro with requery of the control [only works on the original
form (answerCode)
creating an action even when the control has the focus:
[Forms]![CreateC]![answerCode].Form![ACodes].Requery {doesn't requery}
What am I doing wrong? The control shows the answer selections for the first
question and then continues to show the same answer selection regardless of
the question number.
Why does it work so well as a stand alone and falls apart as a subform?
Thanks - I need help!