Hi Again!
I am having issues with a comboxbox who's listitems are populated from a query. Basically I have a Holiday calendar that allows you to see a what holidays a person chosen from the combobox has. Now, you can add more holidays in, but I don't want to save changes until all holidays are put in. Now I want to catch when the user switches persons and hasn't saved their changes back to the SQL Server.
So i'm using the BeforeUpdate event of the combobox and if the user says they wish to keep editing the holidays then cancel out of the combobox change.
The Cancel = True works fine but it doesn't allow any other control to be clicked unless you press escape on the control. I've tried setting the value of the combobox back to the .oldvalue but it simply raises the BeforeUpdate event of the combobox again.
I feel like i'm missing something very obvious here...
I am having issues with a comboxbox who's listitems are populated from a query. Basically I have a Holiday calendar that allows you to see a what holidays a person chosen from the combobox has. Now, you can add more holidays in, but I don't want to save changes until all holidays are put in. Now I want to catch when the user switches persons and hasn't saved their changes back to the SQL Server.
So i'm using the BeforeUpdate event of the combobox and if the user says they wish to keep editing the holidays then cancel out of the combobox change.
The Cancel = True works fine but it doesn't allow any other control to be clicked unless you press escape on the control. I've tried setting the value of the combobox back to the .oldvalue but it simply raises the BeforeUpdate event of the combobox again.
I feel like i'm missing something very obvious here...
