Hey AccessWorld Community,
I'm currently tinkering with an Access app for practice and fun, but I've hit a snag and could use some help (I've attached the form with the issue to this post for reference)
Here's the situation:
In my app, I've set up a combobox "member_selection_C" to select user identifiers from a table "MEMBRES".
After selecting a value in "member_selection_C", an AfterUpdate event triggers, dynamically updating in VBA the SQL of a query named "AfterUpdateIssueDemo_Q".
Then "term_selection_C" is another combobox meant to display values based on the dynamically updated query.
Despite verifying that the SQL updates correctly and the AfterUpdate event fires as expected, "term_selection_C" doesn't update its content automatically (I've made sure to use Me.term_selection_C.Requery just in case...)
At the moment, "term_selection_C" only updates when I manually refresh the form.
Any suggestions on what might be causing this hiccup or how I can troubleshoot it? I'm all ears for your insights and advice!
Thanks a bunch!
I'm currently tinkering with an Access app for practice and fun, but I've hit a snag and could use some help (I've attached the form with the issue to this post for reference)
Here's the situation:
In my app, I've set up a combobox "member_selection_C" to select user identifiers from a table "MEMBRES".
After selecting a value in "member_selection_C", an AfterUpdate event triggers, dynamically updating in VBA the SQL of a query named "AfterUpdateIssueDemo_Q".
Then "term_selection_C" is another combobox meant to display values based on the dynamically updated query.
Despite verifying that the SQL updates correctly and the AfterUpdate event fires as expected, "term_selection_C" doesn't update its content automatically (I've made sure to use Me.term_selection_C.Requery just in case...)
At the moment, "term_selection_C" only updates when I manually refresh the form.
Any suggestions on what might be causing this hiccup or how I can troubleshoot it? I'm all ears for your insights and advice!
Thanks a bunch!