In my MS Access 2003 database I have a form with a control (cboCustomer - just used to select which customer details I want to view) and a MS Graph Chart 8 (graPurchasing). Basically when I select a customer the graph updates to show the purchasing that customer has done. The problem I have is that when I change customer the graph will only update if I click on the graph and then click back to any control on my form. I want the graph to update as soon as I change customer without having to click on the graph then back into the customer drop down or onto a button (basically any other control on the form). I have so far tried the following in the afterupdate of cboCustomer:
I have also tried various SendKeys functions, but, nothing works. Even though I am replicating what I am actually doing manually to get it to refresh in code. Nothing seems to make a difference. Help with this is greatly appreciated.