Form is very slow to open

[Mansoor Ahmad]

Dear All

In my database one of the forms is very slow to open now. It was ok about couple of days ago and now it takes about a minute to open. Other forms are ok.

Can anybody suggest where should I look at to rectify the problem?

Thank you

 

[R6Flyer]

Mansoor,

Have you made any changes to the record source for the form in the last few days?

Cheers

Flyer

 

[Mansoor Ahmad]

Thank you for replying

Actually the form contains tab controls. Form itself is not bound to any data source.

 

[Mile-O]

How many controls does it have in total? The more controls a form has the longer it takes to load and each control takes a different amount of time to load.

 

[Mansoor Ahmad]

Form contains 4 tab controls and three of them have option groups on it.

But the same form was working perfectly ok just a couple of days ago. I cannot remember changing anything.

 

[Rich]

Have you Compacted the db, compiled and saved all modules?

 

[Mansoor Ahmad]

For some very strange reason, when I opened the form today it was working fine and fast.

I did compacted and reapair the database yesterday but even after doing it, it wasn't any better .

Could it be some network problem which affected a part of the database?