子表单移动到父列表框重新查询后的第一个记录 [英] Subform moving to first record after parent Listbox requery
问题描述
现在已经有两个坚实的晚上，主要关注的重点是子表格sfOrderICN中的第一个记录。在父表单上请求列表框。
当我在父表单上使用子表单而不是列表框sfOrderAvgAllQ1时它工作正常，但我正在尝试在捕获时加速表单。（会有帮助吗）
不知怎的，所有记录都被重新获得并失去焦点我认为，这样做，然后在将数据添加到字段后，焦点转到子表单中的第一条记录。
It has been 2 solid evenings now of starring at the focus going to the first record in subform "sfOrderICN" on requering a listbox on the parent form.
It worked fine when i used a subform instead of a listbox "sfOrderAvgAllQ1", on the parent form but I am trying to speed up the form when capturing.(will it help)
Somehow all the records get requeried and lose focus i think, when doing this, and then the focus goes to the first record in the subform after adding data to fields.
推荐答案
是的，表单上的重新查询将强制返回到具有tab-order（0）和记录点的控件第一条记录，包括相关的子表格及其控件。
Yes, a requery on a form will force to return to the control with tab-order(0) and the record pointers to the first record, including the related subform and its controls.
任何建议的行动计划，以获取Access听我的意见？
Any suggested plan of action to get Access to listen to me?
嗯，我知道你没告诉我们你想要什么;因此，我怀疑你没有被告知你想要什么。
更多细节。
从操作系统和Office版开始。
告诉我们你想要它做什么。
告诉我们它在做什么。
尽可能精确。
Well, I know that you have NOT told us what you want; thus, I suspect you haven''t told access what is you want either.
More details.
Start with OS and Office version.
Tell us what you want it to do.
Tell us what it is doing.
Be as precise as possible.
如果列表框失去其值，请尝试此操作：
Try this if the listbox is loosing its value:
PPelle
在我们开始提供猜测和代码之前，请让我们看看OP实际上想要做什么？你可能实际上是正确的;然而，经常猜测只会混淆线程。
Neelsfer通常非常擅长细节，这就是为什么我没有删除线程没有足够的信息开始，所以让他帮我们先帮助他。
PPelle
Please let us see what OP is actually wanting to do before we start offering guesses and code? You might actually be correct; however, quite often guessing just muddles the thread.
Neelsfer is normally pretty good at the details which is why I didn''t delete the thread for not enough information to start with, so let him help us help him first.
这篇关于子表单移动到父列表框重新查询后的第一个记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
