drop down list box which points to Access DB

[Menna]

I have a drop down list box which points to Access DB the form is extremely
slow how should I fix this problem? Thank you.

 

[Adam Harding]

Menna

By points do you mean draws data from or posts data to?

Cheers

PS You Welsh?

 

[Menna]

Draws data from Access DB. Thanks.

Menna

By points do you mean draws data from or posts data to?

Cheers

PS You Welsh?

 

[Adam Harding]

Menna

1) Is it the main data source or a secondary data source.
2) Is it a particualrly large list.
3) Is it Access 2003?

If the answer is Secondary to the first question, No the the Second Question
and Yes to the Third Question i, unfortunately cannot help you.

 

[Menna]

Thanks for your help. Secondary data source, Large list, and Access 2003.

I tried turning off Auto load for the secondary data source but my rules in
my drop down list is not working.

Is there anothe option I have not explored?

 

[Adam Harding]

Filter the list in two sections to reuce the list length? That would reduce
the time taken.

 

[Menna]

I have a customer account# field @ 25K records in the drop down list. How do
I filter the list in two sections? Thanks.

 

[Adam Harding]

Set up three tables + with first table breaking down the accounts starting
1-3, 4-6 and 7-9 so on the form you select which area your account falls
into. Then have one table with all account starting with 1-3 , one with 4-6
and so on.

Make sense. Ideally split it into as many as 9 or ten to really speed
things up then you would need two cascading drop-down lists but it would
speed your form up a lot.