MS ACCESS表单需要很长时间才能导航。 [英] MS ACCESS form taking too long to navigate.

问题描述

我有form1有3种类型的东西叫做 WO 。现在，当我点击''关闭的WO''form2打开显示细节。当我点击后退按钮时，它至少需要2分钟才能返回到form1。但是，Overdue和Open WO不是这种情况，性能也不错。

• form1有查询，每次点击WO按钮都会运行。
• 封闭式WO的数据多于Open或Overdue WO的数据。
• form2仅显示所选WO的一行详细信息。
• 点击form2的后退按钮关闭，form1可见。

I have form1 which has 3 types of something called as WO.Now, when I click on a ''closed WO'' form2 opens displaying details.And when I click the back button, it takes atleast 2 minutes to go back to form1.However, this is not the case with Overdue and Open WO and the perfomance is good.

• form1 has has queries which are run everytime a WO button is clicked.
• There is more data for Closed WO than that for Open or Overdue WO.
• form2 dispays detail of only one row from the WO chosen.
• On click of the back button of form2 it is closed and form1 is made visible.

推荐答案

你需要更好地理解什么是wo.now。除此之外，这个问题突然出现吗？

You need to give a better understanding of what is wo.now. apart, does this problem appear out of nowhere?




嘿它唯一的''WO''它是数据。有三种类型的WO或工作订单，因为它被称为。

我觉得这个问题可能是因为封闭的WO有很多行，但只有在单击后退按钮时才会出现问题。

Hey its only ''WO'' and it''s the data.There are 3 types of WO or Work Order as it is called.
I felt this problem could be because there are a lot of rows for closed WO but the problem occurs only when the back button is clicked.




和快速提问：Overdue和Open中有多少条记录？封闭的wo中是否有大量的记录？

And a quick question: how many records are in Overdue and Open? Is there a huge amount of records in closed wo?




这篇关于MS ACCESS表单需要很长时间才能导航。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！