Slow loading of form (Split form)

Hello Experts,
I am using a Split Form. (Screen Shot attached). The form uses 8 to 10 conditional formatting of the data, like changing colour , depending upon the value.
DOES it slows down the loading  of the form ?

To add: The header of the form also contains some little bit of calculations, on current event.

The record set comprises of around 1100 records only. Whereas i have another similar form with more than 5500 records, but that doesnt slow down.

for more clarity, i am attaching herewith the screen shots :

in Design Mode
in Form Mode
in Form Properties setting mode

Below is the query used in the form :

SELECT ([tblpurchase].[pur_qty]-(select NZ(sum(tblsale.[sale_qty]),0) from tblsale where tblsale.[po_no] = tblpurchase.[PO_No])) AS Salable, Val((select  NZ(sum(tblsale.[sale_qty]),0) from tblsale where tblsale.[po_no] = tblpurchase.[PO_No])) AS Sale, Val((select NZ(sum(tbllifting.[Lift_qty]),0) from tbllifting where tbllifting.[po_no] = tblpurchase.[PO_No])) AS Lifted, Val((select NZ(sum([tblBillEntryFiled].[BE_QTY]),0) from tblBillEntryFiled where tblBillEntryFiled.[po_no] = tblpurchase.[PO_No])) AS BEFiled, ([tblpurchase].[pur_qty]-(select NZ(sum([tblLifting].[Lift_Qty]),0) from tbllifting where tbllifting.[po_no] = tblpurchase.[PO_No])) AS Net_Unlifted, Val((select NZ(sum([tblBillEntryFiled].[BE_QTY]),0) from tblBillEntryFiled where tblBillEntryFiled.[po_no] = tblpurchase.[PO_No]))-Val((select  NZ(sum(tblsale.[sale_qty]),0) from tblsale where [tblSale].[BT_Tax] = 'Tax' and tblsale.[po_no] = tblpurchase.[PO_No])) AS Tax_Stock, Val((select  NZ(sum(tblsale.[sale_qty]),0) from tblsale where [tblSale].[BT_Tax] <> 'tax' and tblsale.[po_no] = tblpurchase.[PO_No])) AS BT_Sale, [pur_Qty]-[BT_Sale]-[BEFiled] AS BT_Stock, *
FROM tblpurchase
ORDER BY tblpurchase.PO_Date DESC;

Also, i want the form to load as fresh and all filters used in previous session shall be cleared. Sometimes, filters used in lst 3/4 sessions get loaded and i have to run the query "Show All" to re cofnirm that records are loaded a fresh. How can i ensure that the form loads all the data, when the form is opened ?

Your kind guidance will be helpful.
Thanking you,
Kamlesh Jain
Kamlesh JainManagerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Gustav BrockCIOCommented:
FC does slow down forms. Easy to check, just remove them an watch.

However, the major slowdown is probably caused by the bunch of subqueries. Again, remove these for a test, and watch.

What to do isn't easy for us to know as we don't know your application neither its purpose.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
John TsioumprisSoftware & Systems EngineerCommented:
If you want to ensure that no Filter is when is loading then
Me.Filter = vbnullstring
Me.FilterOn = False

Open in new window

0
Kamlesh JainManagerAuthor Commented:
i am trying to change the form from Split Form to Sub Form.
Can some one please guide me any good resource / example for using Sub form.
My subform will not be for data entry but purely to call / filter / search records based on multiple criteras (text box / List box / combo box) in the parent form.
Can Conditional formating  be used in Sub Form filtered data ?

Best Regards,
Kamlesh Jain
0
Gustav BrockCIOCommented:
Just add the subform control and fill with data.

At the OnCurrent event of the subform, set the filter for the main form.

Conditional formating can be use for all forms, also in DatasheetView.
0
Gustav BrockCIOCommented:
Suggestions to solve the issue provided.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Query Syntax

From novice to tech pro — start learning today.