Form not refreshing when changing combo box.

[abodi]

I've got 2 forms that don't update. Theres some complex code in the text boxes but essentially they display and filter information based on the dropdown boxes.



On the CSR view leave availabilty forms the boxes update but only when clicking on the date. So i can change site and nothing happens until i click on the date then it updates. I can't figure out why? (only the left most column is enabled to update from the site dropdown.)

On the other leave availability form it has a similar issue. site quota and site available update but changing the site combo box does not update the site approved box. unless you then click the date and then click on the form after updating the date.

I've attached the DB as that is going to be better than any explanation I could provide. your assistance and direction would be so appreciated.

[JeffChr]

so for the forViewLeaveAvailability this seems to work:

Private Sub cboSite_AfterUpdate()
Me.Refresh
End Sub

and for the CSR form (same thing):

Private Sub cboSite_AfterUpdate()
Me.Refresh
End Sub

It would be best not to type this code directly into the VBA module. Open your forms in design mode and use event properties to add this via the after-update event for the combo boxes. Sometimes when you enter control code directly into vba the form does not recognize it so it is best to click your way through the control's property dialogs.