Speed up form Loading

[jambai]

I have two forms. Say form1 and form2. Based on the input in the form1 the form2 has to show the details.
The below is the query I am using for the existing record checking and showing up the new form.

Dim strChkOrder
strChkOrder = "SELECT Order.* FROM [Order] WHERE ((([ORDER])=" & Me.txtOrder & ") AND (([YEAR])=" & Me.txtYear & "));"
Dim rsChkOrder
Set rsChkOrder = CurrentDb.OpenRecordset(strChkOrder, dbOpenDynaset, dbSeeChanges)
If rsChkOrder.RecordCount > 0 Then
blnViewOrder = True
Me.Requery
Let me know the best code for the above lines.

The form2 is loaded very slowly.
Please let me know how to speed up the form2 loading.

Thanks
Jambai

 

[PHV]

Why not having a main form (form1) and a linked subform (form2) ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[jambai]

I am new to MS Access, I don't know how to create a linked subform. I will work on it and let you.

Please let me know how to fine tune the above code snippets in a better way.

Thanks
Jambai