AC 2010: why loading a form last 3 minutes

[juju05]

When i open an application developped in vba access 2010 taht show a part and his property, it lasts almost 3 minutes.

I thought that the forms load all the parts of the table and shows only the first. An arrow allows us toshow the previous, the next, the first and the last.

So I put a filter on the load of the form just to show the part that I want.

It last the same time.

I don't understand why it last so long.

I try to compact the database. It still last.

I have only 3000 parts in my table.

Thanks.

Julien.

 

[pr2-eugin]

How are your tables related? See events associated like Form Open, Form Load, Form Current.. Check if you are adding much pressure. See if you have any Domain function in any of the functions.. Is there any other events that is set to run before? How is this form being opened? AutoExec Macro/Setting of DB..?

 

[shadow9449]

Track Name Autocorrect and Subdatasheets could also make a BIG difference.

SHADOW

 

[juju05]

I find where does it come from. Two events were launch on the loading on the form. The first one has no place there.