查询的输入参数 [英] Input Parameter for Query

问题描述

我知道您可以允许用户在查询期间输入参数。但是，如何通过使用下拉列表框来限制选择？


以下是我要做的一个示例：在customers表的Country字段中可以在标准部分中包含以下内容：


[输入国家/地区]


执行此查询时，用户输入一个国家/地区结果显示。

有没有办法让这个下拉框或列表框有预先定义的选项，而不是允许用户自由输入参数？

I know you can allow a user to type in a parameter during a query. However, how can one limit the choices by using a drop down or list box?

Here is an example of what I am trying to do: In the Country field of the customers table I can have the following in the criteria section:

[Enter a Country]

When this query executes, the user enters a country and the results are shown.
Is there a way to make this a drop down box or list box with pre-defined choices instead of allowing the user to freely type a parameter?

推荐答案

不带参数请求框。通常，我们会通过中间形式来实现这一点。

Not with the parameter request box. Usually, we''ll do this by having an intermediary form.

不带参数请求框。通常，我们会通过提供中介表格来实现这一目标。

Not with the parameter request box. Usually, we''ll do this by having an intermediary form.

你能提供一些例子的链接吗？

Can you provide a link to some examples??

尝试使用搜索表单然后你可以用它来打开记录您的请求...

http://www.thescripts。 com / forum / thread590551.html


如果有帮助，请告诉我。我有几个函数用于重建查询，但我不认为你想要走那条路可能会有点复杂。

Try utilizing a search form then you can use that to open the record you are requesting...

http://www.thescripts.com/forum/thread590551.html

Let me know if that helps. I have a couple of functions I use for rebuilding queries but I don''t think you want to go that route it can get a bit complex.

这篇关于查询的输入参数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！