Link to home
Start Free TrialLog in
Avatar of Kamlesh Jain
Kamlesh JainFlag for India

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of Gustav Brock
Gustav Brock
Flag of Denmark image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Kamlesh Jain

ASKER

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
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Suggestions to solve the issue provided.