使字段成为 Access 2007 中的下拉菜单
我正在 Access 2007 中创建一个 HR 数据库,
我有一个员工信息主表和几个与该表相关的表(例如教育),这些表列出了可以填充该行中的单元格的可接受元素
当我创建表单时被创建为一个受限制的纯文本字段,但我想创建一个下拉列表,其中仅包含允许他们输入的数据以避免混淆。
I'm creating a HR database in access 2007
I have a main table of employee info and several tables that relate to that table ( education for example) that list the acceptable elements that can populate that cell in that row
When i create a form it was created as just a plain text field which is constrained but I wanted to create a dropdown that had just the data that they are allowed to enter to avoid confusion.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
您应该能够右键单击文本框并选择更改为 ->组合框。
You should be able to right-click the text box and select Change To -> Combo Box.
如果您不熟悉创建控件,最好使用向导。从工具箱中选择一个组合框并将其添加到您的表单中,系统将引导您创建所需的组合类型。
您还应该检查您所建立的关系。
If you are not familiar with creating controls, it is best to use the wizards. Select a combobox from the toolbox and add it to your form, you will be guided through creating the type of combo that you want.
You should also examine the relationships you have created.