removing a Duplicate Option Statement error

MrTibbs

Registered User.
Local time
Today, 06:29
Joined
Oct 10, 2001
Messages
101
Opening a form which had an 'On Open' Event Procedure reveals error:
"The expression On Open you entered as the event property setting produced the following error: Duplicate Option Statement"
If I remove the open event the error appears on the load event, if I remove both open and load the error occurs the first time I try and excute any of the action buttons.
I've scoured the code and found nothing untoward .. any ideas?
 
Nope .. I found it 15 seconds after posting the question ... maybe I should post sooner!?
I had 3 modules, one un-used, which had Option Explicit listed twice.
Removed that and the error went away!
 

Users who are viewing this thread

Back
Top Bottom