I have 3 nearly identical forms that contain look-up fields and sub forms. All were functioning properly and in use. and have stopped working as of today 2/2/2012.

The forms contain a report type look-up field and a country look-up field which has On Update code to limit picklist values for Region, City etc.

Both fields report type and Country pass their values to 3 subforms. As an example one of the sub forms is "Training Subjects" that were taught at the event. Upon adding a new record in the subform, the Training Type (report type) and the Country get passed to the subform record and then all the user has to do is select the training subject.

This worked up to today and continues to in one of my 3 forms in the same database/application.

Now in 2 of the forms, when I select the Training Type and then the Country, the On Update code in the Country field hangs. The little swirl icon never stops. Additionally the Country value is not passed to the Subform, but the Training Type is.

The last thing I changed was I re-ordered the fields in the sub forms and "hid" the "Country" and "Training Type fields". I changed all this back thinking it was the problem which didn't help. Additionally it never effected the 3rd functioning form.

Again, the code in all 3 forms are nearly identical. Through trial and error I cut out code one piece at a time in the non-functioning forms. The error stopped when I cut the code from all the subforms that passes the values from Training Type and Country.