Hi,
I'm trying to capture the Old Value and Current Values of all the controls on a form in the form's BeforeUpdate event. I created a function that iterates thru the controls on the form and returns the values I need, the problem is that I need the text <a href=" of a combo box on the form so I setfocus to the control if it is a combo box. If the combo box has the focus before the function runs everything is fine. Else when the function returns the combo box control has the focus and the BeforeUpdate event has now been canceled. Is there anyway to prevent this from happening.
I'm trying to capture the Old Value and Current Values of all the controls on a form in the form's BeforeUpdate event. I created a function that iterates thru the controls on the form and returns the values I need, the problem is that I need the text <a href=" of a combo box on the form so I setfocus to the control if it is a combo box. If the combo box has the focus before the function runs everything is fine. Else when the function returns the combo box control has the focus and the BeforeUpdate event has now been canceled. Is there anyway to prevent this from happening.