I have a simple form with a handful of data entry fields on it. Is there a way to change the order of the fields each time the form is displayed? So user 1 sees Fieldb,FieldC,FieldA, then user 2 sees FieldA,FieldB,FieldC and so on?
我有一个简单的表单,上面有一些数据输入字段。有没有办法在每次显示表单时更改字段的顺序?那么用户1看到Fieldb,FieldC,FieldA,然后用户2看到FieldA,FieldB,FieldC等等?
*UPDATE: My first thought was to call the fields from a lookup table:
*更新:我的第一个想法是从查找表中调用字段:
Me.lbl_a.Caption = DLookup("Label", "Lkup")
Me.Field_A.ControlSource = DLookup("Field", "Lkup")
These basic dlookups just pull the top row from my table, not sure how to call all of my fields and in a different order each time.
Any advice? Sorry for the vague language.
这些基本的dlookup只是从我的表中拉出顶行,不知道如何每次调用我的所有字段和不同的顺序。有什么建议?抱歉模糊的语言。
1 个解决方案
#1
Yes, change the ControlSource for the controls in question:
是的,更改相关控件的ControlSource:
User 1 wanting field1 for first control:
用户1想要field1进行第一次控制:
Me!lbl_a.Caption = "Caption for Field1"
Me!Field_A.ControlSource = "Field1"
User 2 wanting field7 for first control:
用户2想要field7进行第一次控制:
Me!lbl_a.Caption = "Caption for Field7"
Me!Field_A.ControlSource = "Field7"
#1
Yes, change the ControlSource for the controls in question:
是的,更改相关控件的ControlSource:
User 1 wanting field1 for first control:
用户1想要field1进行第一次控制:
Me!lbl_a.Caption = "Caption for Field1"
Me!Field_A.ControlSource = "Field1"
User 2 wanting field7 for first control:
用户2想要field7进行第一次控制:
Me!lbl_a.Caption = "Caption for Field7"
Me!Field_A.ControlSource = "Field7"