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

Steve Medvid
Systems Analyst

Environmental Resource Management