I am having a form on which one of the text box is to capture consumer No. If the user doesn't know the consumer No, next to text box I have provided one button (help button). When user clicks on that button then one list box will be displayed with consumer No and Name. So that when user clicks on any no the consumer no text box will get populated with that consumer no. It is working fine. But it is too slow. Because I am not picking the consumers records as it is. In the Load event where I am using the consumer file I am using the command set filt to natur_code = "4" and not empty(ctaout_dt) and not empty(tvout_dt)
and in the list box I have given the recordsource = consumer.cons_no,name.

When my form starts it takes nearly 15 seconds to display the form. I am having nearly 25000 records in consumer master and also dbf is having nearly 40 fields. I ma using free tables.

Can I expidite this ?


Pl. Help.

Thanks in Advance.

Ashish Patel