Form takes forever to load at Frontend

[shafara7]

So I have this form that will display the task of employee for the week.
I have posted a thread about this before. Here is the link : https://access-programmers.co.uk/forums/showthread.php?t=293894

There is a huge TV that opens the database and display this form BUT it is a backend.
I want to use frontend instead of backend because it will be easier to design new layout.
But the problem is, that form does not load at all in frontend or maybe it takes forever to load. I once let it load for hours and still nothing came out.
I have a 'design mode' database file where I edit the design of my form and it also works perfectly.

Does anybody know what could be the problem?
I am guessing it's because of the linked tabled at frontend which makes it forever to load.

 

[isladogs]

Try creating a query identical to the form record source.
It that takes forever to load then you've confirmed your suspicion.
If so, modify the SQL used to fix the issue.

Also check the table links are correct.

If that's not the issue, disable all code that currently runs in the form open/ load / activate etc events by adding a ' at the start of each line.
Does it now load quickly?
If so, re-enable each line one at a time and retest loading time after each change until you've pinned down the cause.

It may also be worth compacting, recompiling etc. Backup first!

 

[shafara7]

I have tried everything but nothing works. Everything seems to be on the right place.
I also tried copying the Backend to my hard drive and make a linked tables to my frontend, still the form won't show the record in frontend.
And I don't think the data is heavy because I have other forms that contains more data but still works like normal.
Am I missing something here?

 

[isladogs]

I have tried everything but nothing works. Everything seems to be on the right place.
I also tried copying the Backend to my hard drive and make a linked tables to my frontend, still the form won't show the record in frontend.
And I don't think the data is heavy because I have other forms that contains more data but still works like normal.
Am I missing something here?

Well you are obviously missing something .... and I very much doubt you've tried everything

However as you think you have done everything, I suggest you create a new form from 'scratch' and check the loading time as you build up the code.
Don't just copy the form controls & code as you will just repeat the same issues.