I have a form where the On Dirty event has been coded to do the following;
Private Sub Form_Dirty(Cancel As Integer)
Me.mustsave = True
Me.lastupdated.Value = Now
Me.lastupdateby.Value = CurrentUser
I added the 3rd & 4th lines of code today and the fields are not updating. In addition the first field (mustsave) which was previously working correctly is now not working. The other 2 fields are used with the same code in other forms and work perfectly, but not in this form, why?
I've just noticed that all 3 fields are being updated if most fields are changed but if 2 particular combo's are selected the field isn't being updated. There are other combo's on the form and these update the fields OK?
Both these combo's have a Mousedown event, I wonder if that's to blame
It is the OnMouseDown event that is causing it as I've just removed that event form one of teh 2 combo's that weren't updating the fields Ondirty and now when you change the combo it updates the 3 change fields.
Why is this and is there a way around it as I need the OnMousedown event of these 2 combo's
Tried the OnChange event and I can't use that as what happens with this field is that I use the OnClick event to bring up a calendar, then the OnMouseDown event selects a date and populates the combo box.