>I put in some wait window commands and found that the .OpenTables method is firing and then the .BeforeOpenTables method is firing. I don't think that this is right. Any idea what is going on here?

Just to clarify some confusing terminology, OpenTables is a method whose default behavior is (no surprise) to open tables. This also triggers the BeforeOpenTables event. So any code you put in OpenTables will execute, then the default OpenTables behavior will occur, during whiich BeforeOpenTables will fire.

The long and the short of it is that your BeforeOpenTables code will execute after your OpenTables code.