How to stop _change event for objects pre-loaded with information

[ravikiran]

Hello Gurus,

I have a query regarding the combobox_change event.

I use a combobox which is initialized with data from the DB. The same combo box has a _change event which is being triggered even when I try to pre-load the data from database.

Combobox code when the form is initiated.

Please Login or Register  to view this content.

This updates the combobox with the text from RslAudit field and also updates the label beside it with the "Audit Date."

Combobox _change event code.

Please Login or Register  to view this content.

I also have the above code that is triggered when the Audit combobox is changed. When it is selected as "Audit Confirmed", it asks for "Audit Date." (which is supposed to be pre-filled from database first time).

How can I overcome this?

Regards,
Ravi.

[mrice]

Suggest setting the Application.EnableEvents flag at appropriate places in the code.