SQL/VB Problem

I am having a bit of an sql problem with the application that I am making. Here is my sql section

If sqltxt.Text <> "" Then
mysql = sqltxt.Text & ""
Else
mysql = "select * FROM Transactions WHERE ((([Transactions].[Include])=Yes)) "
End If



Now, sqltxt is a text box that a user can insert sql or choose automated sql statements to appear in. The "else" sql statement works, but when I do any sql that calls a specific field in the table, it says that it doesn't exist. For example, the first field in my table is [Transactions].[TID], or just TID, but it will say "Item not found in collection."


Any ideas what i'm doing wrong? This situation is hard to describe, but i figured i'd give it a shot.

what line does the error occur on?

on the sql export it tells me that the item doesn't exist in the table. It does that even if I use the include that does work in the else statement