Unbound form control won't requery/refresh
Posted on 2011-02-15
I have been working for an entire day at getting a single unbound control to requery. Refresh. whatever.
A single form.
2 combo boxes.
1 is populated and woolah!
The second one is filtered to the results limited by the 1st combo box's selection.
I've done this type of reference a hundred times but this time I can't get the darn combo box #2 to actually requery itself to the results of the newly changed combo box #1. Both are unbound. Both are on the same form. Both are enabled, visible, unlocked.
Funny, the sql query on the rowsource for combo box #2 works great. The combo box doesn't.
I've tried access macros using actions:
runcommand with refresh, runcommand with run or just fun ol' macro action requery.
I've tried using different vba options:
I've tried putting the macros/vba on the after update event of combo #1.
As well as the on enter event, on got focus event, on click event for combo #2.
Problem with the on enter and on got focus events is that, combo #1's action can't set the focus to combo #2 when I use those. So I'm stuck with on click but I can't get it to work.
Please help me. This is my mountain. I must get over it!