logical operator as a variable (syntax?)

[markjkubicki]

I've got a bit of a wacky condition (has to do with an inherited mess..)
I need to make to operator in an if statement variable, and could use some help with getting the syntax correct:

so it would go like this (or so I thought), but it "seems" to be wreaking havoc to the for next loop that it's nested in...


I'm getting a "next without for" error

For Each tdf In dbs.TableDefs 'loop thru all of the tables in the project

            ' Relink connected tables for only the type of backend file being relinked
            If vlinktype = tbl Then
                  If Left(tdf.Name, 3) <> "tbe" Then
            Else
                  If Left(tdf.Name, 3) = "tbe" Then
            End If

            .... large block of code

                 end if

Next tdf

many thanks in advance,
mark

[June7]

What does 'wreaking havoc' mean - error message, wrong results, nothing happens?

Have you step debugged?

[John_G]

Your if-then-else code is not making sense - you don't have enough End If lines. This is the cause of the "next without for" error - even though you have it is the code, Access is confused.

You don't need both checks on
Left(tdf.Name, 3)

If one of them is not true, then obviously the other one is true.

It is not clear from your code the conditions required for the "large block of code" to be executed.

Can you clarify, please?

[markjkubicki]

OK.... so wreaking havoc is a exaggeration..
the code won't compile on opening; I get an error " "next without for" -however, there is a "for"; I can see how access is confused by code in question

it may be a clearer question if I asked: can I pass an operator (to an if statement) as a variable?

depending on where the code was called, the operator would be EITHER an "=" or "<>"

[June7]

Never tried that. Might require Eval() function.

[markjkubicki]

thanks... but that didn't work; i think I simply need to rethink the organization / logic of the code