Form/subform 'locking up' when combo item selected ?

[liamfitz]

When I select an item in a combo box, it 'locks up' the whole form. I've tried putting my code, from the On_Click into the On_Change event. It updates a recordset/table, when item is selected - all standard stuff... or so I thought.

 

[liamfitz]

My sincere apologies. I've now overcome this, ( it helps if one adds a recordset.Movenext IN a loop, when going through a recordset - using the Do While Not(recordset.EOF ) and Loop - lest it becomes an infinite loop ) which is exactly what caused this 'lock'. Thanks for your interest.