Reading off a table and displaying the result in a textbox

[noks]

Hi guys.

Wheneva i load a certain screen i wanna read off a table and display the results in textbox (preferably a lable but it seems like that's not allowed - i know in VB6 it's possible)

Curently i use queries to do that, i append my data to some temp tables then send it to the original tables. I not longer wanna do that as it takes too much time.

Pls help

 

[llkhoutx]

Results can not be displayed in a label, but they can be displayed in the label's caption property.

If appending to a temp table takes "too long" you must have a huge amount of data. "Too long" is relative. Hours is "too long," a few seconds is not.

If you are appending to a temporay table, why can't that data be appended to the "final" table?

I'd keep using the method you are presently. That's a reasonlable way it to do it. Saving data is a label to append to a table doesn't pass the smell test, i.e. it stinks.

 

[noks]

not 2 long as the amount of time... as in the process... i wanna take out the temp tables.

I append to the temp tables cos the results r usually for certain accounts the on the other tables i do joins whereby i enter the other customers which contain nothing so that they'll display 0 value, den i send ol that data to the masterfile (the one i use in a query for the form) - for me that's a long process

Another thing is i wanna do this coz i wanna read straight from the sql tbl that is linked to ma form (live data)

The temp tbls contain static data and they're appended only once a day

Noks