我在MS Access中有项目。我有一个表格,其中有一个组合框。我想知道何时从该组合框中选择一个项目并点击提交按钮那么它应该打开一个从表中过滤数据的报告。所以我只想根据表格中组合项目的选择从报表中的表中获取特定数据。 任何人都可以帮忙吗? br /> 谢谢。
Hi, I have project in MS Access.In that I have one form in which there is one combobox .I want to know when I select an item from that combobox and click on submit button then it should open a report which filter data from table.So i only want specific data from table in report based on selection of item from combobox in a form. Can anyone help? Thanks.
推荐答案我有在MS Access中的项目。我有一个表单,其中有一个组合框。我想知道当我从该组合框中选择一个项目并单击提交按钮然后它应该打开一个报告从表中过滤数据。所以我只想要根据表格中的组合选择来自报表中的特定数据。 任何人都可以帮忙吗? 谢谢。 Hi, I have project in MS Access.In that I have one form in which there is one combobox .I want to know when I select an item from that combobox and click on submit button then it should open a report which filter data from table.So i only want specific data from table in report based on selection of item from combobox in a form. Can anyone help? Thanks.
我们需要比这更具体的信息,例如:
We need much more specific information than this, such as:
我们需要比这更具体的信息,例如: We need much more specific information than this, such as:
组合框的形式名称是cm bpalletno" 报告名称为" ProductionReport" ,记录来源为表" PRODUCTION" $组合框中的b $ b我使用向导选择表(" PRODUCTION" )的字段(" palletno" )。 现在我想要从组合框中选择palletno 所有字段都是文字类型 例如 PalletNo CuastomerCode Qtyonhand Shippeddate状态 1西尔斯1060 11/12/2007运费 2 MACY 1600 11/01/2007运费 3 OLD NAVY 1000 12/02/2007运费 4 DKNY 500 12/03/2007待运送 现在我的表格我有组合框有项目清单。 西尔斯 MACY OLD NAVY DKNY 当我选择MACY时,从组合框中点击按钮(btnsubmit)然后它应该打开它将显示的报告 客户详细信息 --------- -------------------------------------------------- ---------------------------------------------- PalletNo CuastomerCode Qtyonhand Shippeddate状态 2 MACY 1600 11/01/2007运费 如果我选择Sears从combobox然后它会告诉我 客户详情 --------------------- -------------------------------------------------- ---------------------------------- PalletNo CuastomerCode Qtyonhand Shippeddate status 1西尔斯1060 11/12/2007运费 就是这样。 我想现在你可以理解非常容易。不要担心abt names.just给我解决方案使用任何可行的名称。 我将在我的代码中更改它。 谢谢你的回复
In form name of combobox is "cmbpalletno" name of report is "ProductionReport"and record source is table "PRODUCTION" in combobox I select field("palletno") of table("PRODUCTION") using wizard. now I want to select palletno from combobox all fields are of type Text example PalletNo CuastomerCode Qtyonhand Shippeddate status 1 Sears 1060 11/12/2007 SHIPPED 2 MACY 1600 11/01/2007 SHIPPED 3 OLD NAVY 1000 12/02/2007 SHIPPED 4 DKNY 500 12/03/2007 TO BE SHIPPED now in my form I have combobox which have item list. Sears MACY OLD NAVY DKNY when I select "MACY" from combobox and click on button(btnsubmit) then it should open report in which it will show Customer Details --------------------------------------------------------------------------------------------------------- PalletNo CuastomerCode Qtyonhand Shippeddate status 2 MACY 1600 11/01/2007 SHIPPED if i select "Sears" from combobox then it will show me Customer Details --------------------------------------------------------------------------------------------------------- PalletNo CuastomerCode Qtyonhand Shippeddate status 1 Sears 1060 11/12/2007 SHIPPED that''s it. I think now u can understand very easily.don''t worry abt names.just give me solution using anyname feasible for u. I willl change it in mine code. Thanks for ur reply
尝试: Try: 展开 | 选择 | w ^ rap | 行号
更多推荐
通过Combobox选择过滤报告数据
发布评论