>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???
Steve Medvid
Systems Analyst
Environmental Resource Management