非记录源-不随行更新 [英] Non Recordsource - Does not update with the row
问题描述
我有一种用于将信息输入到表格中的表格.
I have a form that i am using to input information into a table.
表定义:
Field0 - AutoNumber
Field1 - Text
Field2 - Number (Loose Referential Integrity)
Field3 - Number (Loose Referential Integrity)
控制-记录源:
TextBox - Field1
ComboBox1 - `Unbound`
ComboBox2 - Field2
ComboBox3 - Field3
关于表格:
New Record - ComboBox1 defines the selections available in ComboBox2
Edit/View Record - ComboBox1.Value is deduced by the ComboBox2.Value
最初,此Form是使用Single Form布局设计的,但是最终用户想要更多的Continuous Form布局,现在当我查看值列表时,ComboBox1是跨越所有Rows
的相同值.我最初使用Form_Current
事件来处理向后的继承,以从ComboBox2派生ComboBox1的值.这与原始表单时的工作方式不太一样.
Originally, this Form was designed with Single Form layout, but the end-user wanted more of a Continuous Form layout and now when i view the list of values, ComboBox1 is the same value acrossed all Rows
. I was originally using the Form_Current
event to handle the backward's inheritence to derive the Value of ComboBox1 from ComboBox2. This is not quite working like it originally did when it was a Single Form.
如何将Single-Form Form_Current方法迁移到Continuous Form逻辑,以便将每一行作为自己的单个实体进行评估?
How do i migrate a Single-Form Form_Current methodology to a Continuous Form logic so that each row is evaluated as its own single entity?
当前,如果我去看单行,它将从ComboBox2撤消ComboBox1,但是它将撤消连续表单"中的所有行,而不仅仅是我当前所在的行.
Currently, if i go look at a single row, it evaulates ComboBox1 from ComboBox2 but it evaulates all of the rows in the Continuous Form not just the row i happen to currently be on.
推荐答案
这是一个不断出现的问题.您不能明智地连续使用未绑定的控件.根据您的工作状况,有多种解决方法.最好的方法通常是将编辑保留为弹出式表单.
This is a question that keeps coming up. You cannot sensibly use unbound controls in a continuous form. There are various work-arounds, according to what you are doing. The best is usually leave the editing to a pop-out form.
替代方法包括将文本框设置为绑定值,并仅将组合框标记为编辑某某内容".
Alternatives include setting a textbox to the bound value and just marking the comboboxes "edit such-and-such".
这篇关于非记录源-不随行更新的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!