组合框列表 [英] Combo Box Lists

问题描述

首先 - 关于这个（好的，或任何）程序，我不是很技术性的，所以像对待孩子一样解释它< vbg>>


目前我有三张桌子，其中有2张是随附的 - 他们是tbl_breeds，tbl_clubs和tbl_rescues


他们有一个共同的字段 - 品种 （没有引号）


我在表格中使用了一个组合框（用于俱乐部和救援表），用于品种。值。如何设置它以便组合框（记录源将是tbl_breeds）自动填充那些尚未包含在品种表中的表单条目？


我目前正在使用Access 2003.


我有一个旧的数据库，有人为我设置了类似但我无法复制的数据库。有几个参考SELECT DISTINCTROW


希望这是有道理的，有人可以帮助我！


提前致谢，


RLynn

First off - I am not very technical when it comes to this (well, or any)program, so explain it as you would to a child <vbg>>

Currently I have three tables with accompanying forms for 2 of them - they are tbl_breeds, tbl_clubs and tbl_rescues

They have a field in common - "breed" (no quotes)

I am using a combo box in the forms (for the club and rescue tables) for the "breed" value. How do I set it up so that the combo box (record source would be "tbl_breeds") is automatically populated with those form entries which are not already included in the breeds table?

I am currently using Access 2003.

I had an old database someone had set up for me that did something similar but I cannot duplicate it. There were several references to "SELECT DISTINCTROW"

Hope this makes sense and someone can help me out!

Thanks in advance,

RLynn

推荐答案

首先 - 我不是很技术它来到这个（好的，或任何）程序，所以解释它就像你对一个孩子一样< vbg>>


目前我有三张桌子，附带2张表格他们 - 他们是tbl_breeds，tbl_clubs和tbl_rescues


他们有一个共同的领域 - 品种 （没有引号）


我在表格中使用了一个组合框（用于俱乐部和救援表），用于品种。值。如何设置它以便组合框（记录源将是tbl_breeds）自动填充那些尚未包含在品种表中的表单条目？


我目前正在使用Access 2003.


我有一个旧的数据库，有人为我设置了类似但我无法复制的数据库。有几个参考SELECT DISTINCTROW


希望这是有道理的，有人可以帮助我！


提前致谢，


RLynn

First off - I am not very technical when it comes to this (well, or any)program, so explain it as you would to a child <vbg>>

Currently I have three tables with accompanying forms for 2 of them - they are tbl_breeds, tbl_clubs and tbl_rescues

They have a field in common - "breed" (no quotes)

I am using a combo box in the forms (for the club and rescue tables) for the "breed" value. How do I set it up so that the combo box (record source would be "tbl_breeds") is automatically populated with those form entries which are not already included in the breeds table?

I am currently using Access 2003.

I had an old database someone had set up for me that did something similar but I cannot duplicate it. There were several references to "SELECT DISTINCTROW"

Hope this makes sense and someone can help me out!

Thanks in advance,

RLynn

试试这个...

Try this ...

展开 | 选择 | Wrap | 行号

谢谢 - 我/我如何输入代码？

Thanks - where/exactly how do I enter the code??

谢谢 - 在哪里/我究竟如何输入代码？

Thanks - where/exactly how do I enter the code??

在组合框的属性中将它放在行源属性中

In the properties of the combobox put this in the Row Source property

这篇关于组合框列表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！