>>How do U reference a textbox object within SQL code? I have two grids. A parent and child. I also have two data controls on the screen (hidden) to open the data files. In the data control for the child I want to an SQL statement to reference the first data control for the field Facility ID. I have a textbox which displays facility ID and I am trying to make use of that. Anyway here is something i am trying which does not work.
>>
>>Select * from [Well Information] Where [Facility ID] = _
>>"'"&txtFacility_ID.Text&"'"
>>
>>If I could reference the data control (Data1) object directly, that would be straight forward, but I was unable to come up with that synatx either. So, I just added hidden text boxes. This seemed simple...
>>It is always the easy stuff that is so time consuming...
>>Any help is appreciated.
Steve
>
>Figured it out - Added a space before & after "&" and added additional "'"s... Hey does anybody read this VB Thread???
I do all the time. But all our Foxies are too much into Fox over there :)
Some things are better be left unknown...NOT!!!