Need to refresh (requery?) a datasheet view subform from the main form combo box
I have seen a billion threads that appear to be very close to what I need, but I still can't get it correct. I therefore apologize if this has already been answered. I have attached a generic version of the database I am building for your reference.
The main form is Value_Chain. This form has combo boxes at the top which input into each of my queries (I am aware the queries are inefficient). The results of 4 of the queries are shown as subform datasheets. I would like all these datasheets to update everytime a new selection is made in each of my combo boxes. Please note that the "Date" combo boxes are required selections.
Currently the subforms will ony update after a combo box change when I go to design view and back to form view. This is obviously not practical.
I am not an Access genius (obviously), so please simplify when providing explanations. I would prefer to not get into VBA, but I can if required (was thinking "After Update" event).
Then tell us what is, ...or is not happening, and state how you want it fixed.