Hi All, I was sure I had tested this form totally and all fields were working as intended. However I lost a file and had to redo a very simple refresh macro and now when i test i am not getting the desired result.
So i have a macro to update the StatusDesc field which is on StatusSub form. As soon as I change a status code in a status listbox the description updates.
As soon as I add another listbox to the mainform (which is working fine), the StatusDesc box does not update as soon as the status code is changed in the list box. For this to work I am having to click in the StatusDesc field which instantly updates the field. I can then return to the Status listbox, update its contents but now it instantly updates the Statusfield. So as long as i give focus to the StatusDesc field once, it will updates correctly afterwards but not until I do this.
I am a little puzzled. Are there any immediate obvious errors anyone can suggest.