使用列表/组合框plz帮助进行参数查询 [英] Parameter query with a list/combo box plz help
问题描述
首先描述一下情况，为您提供见解。有一张摩托车表（注册号，品牌，型号，颜色，没有。等等）我希望能够运行一个查询，只允许我查看一个品牌的自行车。
i想知道是否有方法使参数提示列表/组合框包含motorcycles表中的值，这样只能查询（搜索）表中的摩托车。
我已尝试使用带有未绑定组合框（Makecombo）的表单并使用按钮运行宏以打开查询。在查询中使用条件[Forms]！[Motorcycles Make]！ [Combo25]无论怎样，无论是什么让我选择使用组合框，然后点击查询打开的按钮，显示为空白。
任何帮助都会非常适合。= D
请回复ASAP。
Firstly a description of the situation to give you an insight. have a table of motorcycles (Registration no.,makes,models,colour,no.owners, etc. and i would like to be able to run a query that allowed me to view only bikes of one make.
i would like to know if there is way of making the parameter prompt a list/combo box contain the values within the motorcycles table so only motorcycle makes within the table can be queried (searched).
ive tried out using a form with a unbound combo box (Makecombo) and using a button to run the macro to open the query. within the query using criteria "[Forms]![Motorcycles Make]![Combo25]" how ever no matter what make i select using the combo box and then click the button the query opens and appears blank.
any help would be greatly appriciated. =D
plz reply ASAP.
推荐答案
首先描述一下情况给你一个见解。有一张表摩托车（注册号，品牌，型号，颜色，没有。等等，我希望能够运行一个查询，只允许我查看一个品牌的自行车。
i想知道是否有方法使参数提示一个列表/组合框包含摩托车表中的值，这样只能查询（搜索）表中的摩托车制造。
我已尝试使用带有未绑定组合框（Makecombo）的表单，并使用按钮运行宏以打开查询。在查询中使用标准[Forms]！[Motorcycles Make]！[Combo25]"然而，无论是什么让我选择使用组合框，然后单击按钮查询打开并显示为空白。
任何帮助都会非常受欢迎。 = D
请尽快回复。
Firstly a description of the situation to give you an insight. have a table of motorcycles (Registration no.,makes,models,colour,no.owners, etc. and i would like to be able to run a query that allowed me to view only bikes of one make.
i would like to know if there is way of making the parameter prompt a list/combo box contain the values within the motorcycles table so only motorcycle makes within the table can be queried (searched).
ive tried out using a form with a unbound combo box (Makecombo) and using a button to run the macro to open the query. within the query using criteria "[Forms]![Motorcycles Make]![Combo25]" how ever no matter what make i select using the combo box and then click the button the query opens and appears blank.
any help would be greatly appriciated. =D
plz reply ASAP.
如果您只想查询数据，可以构建查询以查看摩托车表。在制造中列，将[哪个Make？]放在标准行中。这将提示用户输入他们想要搜索的Make。
希望有所帮助，欢迎来到剧本！
Brad。
If you just want to query the data, you could build the query to look through the motorcycle table. In the "make" column, put [Which Make?] in the criteria line. This will prompt the user to type in the Make that they would like to search.
Hope that helps, and Welcome to theScripts!
Brad.
嗨欢呼感谢您的帮助。
您所说的方法可以使用，但我不希望用户能够搜索不在摩托车表内的品牌，我也不想手动输入品牌，因为它可能导致验证和数据输入错误是否有办法放置组合列表/下拉列表中的摩托车表中的值（在摩托车表中我已经有一个下拉值列表，因此不必手动输入。
hi cheers thanks for the help.
your method stated could be used but i don''t want the user to be able to search for makes that aren''t within the motorcycles table and i also don''t want to have to type in the make to be search manually as it can lead to validation and data entry errors is there a way to put a combo box/drop down list of the values in the motorcycles table (in the motorcycles table i already have a drop down value list of makes so they do not have to be entered manually.
嗨欢呼感谢您的帮助。
您所说的方法可以使用，但我不希望用户能够搜索使它不在摩托车表内，我也不会想要手动输入make进行搜索，因为它可能导致验证和数据输入错误是否有办法在摩托车表中放置值的组合框/下拉列表（在摩托车表中我已经有下拉值列表，因此不必手动输入。
hi cheers thanks for the help.
your method stated could be used but i don''t want the user to be able to search for makes that aren''t within the motorcycles table and i also don''t want to have to type in the make to be search manually as it can lead to validation and data entry errors is there a way to put a combo box/drop down list of the values in the motorcycles table (in the motorcycles table i already have a drop down value list of makes so they do not have to be entered manually.
当然......在你的表单上使用向导构建一个组合框。让它在你的查询中寻找价值（特别是摩托车的制造）。
然后你可以用两种方式做事（至少:)。如果您只是想打开查询，可以将组合框控件名称放在查询的条件行中（例如Forms！[frmBikes]！[cboMakes]）。然后你会有组合框的AfterUpdate事件说...
Sure... On your form build a combo box using the wizard. Have it look for values in your query (specifically the make of motorcycle).
You could then do things one of two ways (at least :). If you just wanted to open the query, you could put the combo box control name in the criteria line of your query (such as Forms![frmBikes]![cboMakes]). Then you would have the AfterUpdate event of the combo box say...
这篇关于使用列表/组合框plz帮助进行参数查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
