将一个组合框过滤到另一个填充子表单的组合框？ [混淆] [英] Filter one combo box to another that populates a child form? [confusing]
问题描述
然而，像这样的东西（在标题中提到）仍然会让我感到困惑。
好吧所以这里是我的问题。
i想创建一个包含以下内容的表单：
1. 2000和2010的组合框。
2 。州名的另一个组合框（即阿拉巴马州，阿肯色州等）
3.儿童表格/电子表格或表格中的任何内容。
当我输入电子表格/子表单时，它会保存到我的表格中。
希望这不会太混乱。
----
这就是我想要它做的事情：
1.当我选择2000年时，我选择州纽约，我可以输入子格式以放入县和人口＃。
2.当我选择另一年，2010年，我可以选择相同的州纽约，但是子形态将是空白的，因为我还没有打字。我只输入了2000年的一个。
我的老板要我这样做，以便他能够在2000年和2010年看到纽约州的所有县。
谢谢！
所以我需要同步两个组合框并添加一个child。我可以在哪里输入我的字段和数据
1 cbobox将是年份 （2000,2001,2002,2003等）
另一个cbobox将是州 （与NY，NJ，NH，RI等）
让我向最简单的人解释一下。
i想要选择[所有[州]，但当我选择[州]时，它只会填充该州的东西。当我选择另一年，相同的州时，它将仅填充该特定年份的那个州。
我必须制作多少张桌子？
1对于州代码，1年，1表示我的儿童表格数据？
谢谢！
我建议你看看首先在表单上过滤。只需要主表。可以从主表中使用的值填充组合框。
欢迎使用字节！
1。一个2000和2010的组合框。
在表单的工具栏中，选择组合框。并选择我希望表格查找表格或查询中的值，然后选择适当的表格和字段。
2.另一个州名称组合框（即阿拉巴马州，阿肯色州等）
与上述相同。
3.儿童表格/电子表格或其他任何名称放在表格中。
它被称为子表格。并且也可以在工具栏中找到。选择输入数据所需的任何表格，然后在出现提示时按年份字段和州字段链接表格。
这应该有用，你的问题也不会太混乱，所以希望我的答案也不是。
Hi guys. I''m new to this forum. I had zero knowledge of access when i started interning at my company. it''s been only 3 weeks and i''m somewhat getting the hang of it.
however, stuff like this (mentioned in title) can still be confusing for me.
ok so here''s my problem.
i would like to create a form that contains the following:
1. a combo box for 2000 and 2010.
2. another combo box for state names (i.e. alabama, arkansas, etc)
3. a child form/spreadsheet or whatever it''s called that is put in the form.
and when i type to the spreadsheet/child form, it saves to my table.
hope this is not too confusing.
----
this is what i want it to do:
1. when i select the year 2000, and i select the state New York, i can type in the childform to put in the county and population #.
2. when i select another year, 2010, i can select the same state, New York, but the childform will be blank because i didn''t type anything yet. i only typed in the 2000 one.
my boss wants me to make it so that when he can see all the counties in New York state in the year 2000 and 2010.
THANKS!!
So I need to sync two combo boxes and also add a "child" where i can type my fields and data
1 cbobox would be "Year" (with 2000, 2001, 2002, 2003, etc)
another cbobox would be "State" (with NY, NJ, NH, RI, etc)
let me explain it to the simplest i can.
i want to select [year] with all [states], but when i select [state], it will only populate the stuff for that state. when i select another year, same state, it will populate only that state for that particular year.
how many tables do i have to make?
1 for state codes, 1 for years, and 1 for my data for the child form?
Thanks!
I suggest you look through Example Filtering on a Form first. Only the main table would be required. The ComboBoxes could be filled from the values used in the main table.
Welcome to Bytes!
1. a combo box for 2000 and 2010.
In the toolbar for the form, choose "combo box" and select "I want the table to look up the values in a table or query", then select the appropiate table and field.
2. another combo box for state names (i.e. alabama, arkansas, etc)
Same as above.
3. a child form/spreadsheet or whatever it''s called that is put in the form.
It''s called a "subform" and can be found in the toolbar as well. Choose whatever table you need to enter the data, then link your table by both your year field and state field when prompted.
This should work, and your question wasn''t too confusing, so hopefully my answer isn''t either.
这篇关于将一个组合框过滤到另一个填充子表单的组合框？ [混淆]的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
