Continuous loop using a UserForm

[j_Southern]

ear Members

The attached workbook and code gives UserForm1. Some fields of the table "AllOrders" are used to populate ListBox3 . The OrderNo field when selected is used in the ListBox3_AfterUpdate proceedure to identify the record in the table to be used to populate TextBoxes in the UserForm1.
This is the offending code

Please Login or Register  to view this content.

This is a technique I have used before succesfully. This time, for reasons that I have not been able to fathom, Highlighting the Order in ListBox3 starts off a continuous loop, as if the ListBox was continualy updating. I must be doing something wrong and I would be delighted if somebody could point out what it is. The password is magpie.
John

[pike]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.