POPULATING OR FILLING TEXT BOXES WITH DATA FROM A DATABASE

[TNN]

I can fill a db grid's fields with data from a database using a data control and writing SQL for the Recordsource property. Load time is relatively fast considering the number of fields that I can fill.

Is there a way to write SQL and fill text boxes with data from a database without using the recordset methods which are too slow.

I have 199 text boxes to fill with database data and using the recordset methods it takes approx 8 to 11 seconds to load all 199 text boxes.

Any help or suggestions appreciated.

TNN, TOM
TNPAYROLL@AOL.COM

TOM

http://WWW.TNPAYROLL@AOL.COM

 

[CuJo]

Why don't you just asign the textbox datafield and datasource according to your database? Maybe I'm not understanding the question..

<---CuJo

 

[TNN]

Cujo,
You mean bind the text boxes to the database fields? I looked at this before but am going to have to look again since you bring it up. This might do at least for some of the text boxes.
Sometimes we overlook the obvious and make things harder on ourselves. Thanks Cujo.

TNN, TOM
TNPAYROLL@AOL.COM

TOM

http://WWW.TNPAYROLL@AOL.COM