个人记录子表单
我对访问相当陌生,我想知道表格。
在我的表单中,我希望根据用户选择的行显示某些字段值。
因此,假设用户选择 B 行,我想要一个仅显示 B 行数据的子表单。
这可能吗?如果可以,如何实现? :)
谢谢!
I am fairly new to access and I am wondering about a form.
In my form, I want to have certain field values displayed based upon which row the user selects.
So, pretend a user selects Row B, I want a subform that displays data from only Row B.
Is this possible, and if so how? :)
Thanks!
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
您甚至不需要子表单。
您的主表单是一个连续表单,您的数据行显示在表单的详细信息区域中,对吧?
如果是,您可以将绑定的文本框放在表单页眉或页脚中,它们将显示所选行的值。
以下是我刚刚制作的一些示例屏幕截图。
它是 Access 2000,是德文版(这是我这里唯一的 Access 版本),但您会明白的。
设计模式:
(在英语 Access 版本中,“Formularkopf”表示“表单标题”,“Detailbereich”表示“详细信息”。)
在运行时:
请注意,表单标题中绑定到 Field2 的文本框会自动显示当前所选行中 Field2 的值。
You don't even need a subform for this.
Your main form is a continuous form and your data rows are displayed in the form's detail area, right?
If yes, you can just put bound textboxes in the form header or footer, and they will display the value of the selected row.
Here are some example screenshots I just made.
It's Access 2000 and it's in German (that's the only Access version that I have here), but you'll get the idea.
Design mode:
("Formularkopf" means "form header", and "Detailbereich" is "Detail" in English Access versions.)
At runtime:
Note that the textbox in the form header, which is bound to Field2, automatically displays the value of Field2 in the currently selected row.