form_activate problem

[polina]

On the form_activate i have an error trapping routine

What i want to do is if the certain error occurs, I want the form to stop activating ( in other words, form wouldn't open)

Please suggest a solution.

Thanks

 

[charityg]

You need to put the error trapping in the OnOpen event of the form, and then set Cancel=1 if you get a certain error.

Or from your OnActivate event, if you hit the certain error,
DoCmd.close