>>>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 :)

I read this from time to time (mainly to clear the notice of VB msgs in the ongoing status (g))
anyway if I'm not using fox I much rather use Delphi,C++, perl or whatever than use VB .. (eg)

Arnon