I respect your time, no need to look at anything else on the attachment but what I refer to here. Only need to look at form f01Agents and query q01Agents.
After not having this issue for years it appears now. Going to query q01Agents the first field is Titles_IDa, a combo field. The next two fields "AbbreviationB","TitleNameB" are linked to the first "Titles_IDa". When the selection on the combo field "Titles_IDa" changes the other two changes instantly. That is perfect.
Opening form "F01Agents" and fifth from the top the field "Titles" can be seen. Making a different selection does not result in an immediate update of the grey field to the left which is "AbbreviationB". Exiting the form and returning see the field being updated. It can be seen on the VBA code page that, requery, refresh, Me.dirty etc were tested, not working, it was commented out. The question is here to result the form to instantly update again. There are 4 more instances of the same on this form "f01Agents" seed addresses.
It never happened before. I did increase the size of query "q01Agents". I don't know if one of the added field causes the change, or is the query too big now? It looks like if I use VBA on the form that it will solve the issue. Hoping that I only need to use the VBA on less than 10 forms in my application. To set up the VBA on 300 forms, maybe I will not live long enough to finish that.