要预览的报告列表。 [英] List of reports to preview.

问题描述

大家好。我有点卡住了。需要一些帮助。


我有一个未绑定的组合框，我想在列表中列出所有报告。


我发现了网站上有多个例子，但是无法让它们工作。


我的组合弓被称为ComboReports，我将Row Source Type设置为Table / Query。在RowSource框中，我输入了

Hi Guys. Am a bit stuck. Need some help is poss.

I have an unbound combo box in a form that I want to list ALL reports in.

Ive found multiple examples on the site but cant get them to work.

My combo bow is called ComboReports and I have set Row Source Type to Table/Query. In the RowSource box I have input

展开 | 选择 | Wrap | 行号

推荐答案

您可以使用此来填充组合框：

You can use this to populate the combo box:

展开 | 选择 | Wrap | 行号

当我把表单中的第一个代码串而不是文本我在组合框中没有报告。


我还尝试仅使用原始框中的第二个代码串，这会产生一个错误，说Charactors发现了SQL语句的结尾。

when I put the first string of code in the form rather than the text I get no reports in my combo box.

I also attempted to only use the second string of code with my original box and that brings up an error saying "Charactors found ant the end of SQL statement.

第3行到第11行的第一组代码应放在表单的On Open事件中。第二组代码（第3行）位于组合框的After Update事件中;这将导致报告在从列表中选择后立即打开。这样就无需使用命令按钮和用于检查用户是否从组合框中进行选择的逻辑。


Pat

The first set of code, from lines 3 to 11, is meant to be put in the On Open event of your form. The second set of code (line 3) goes in the After Update event of your combo box; this will cause the report to open in a preview as soon as it is selected from the list. This eliminates the need for a command button and the logic that goes into checking whether the user made a selection from the combo box yet.

Pat

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