Combo Box Question

[LizM]

Hi

I have a combo box on a form that populates from a parameter query, so the list only contains items that match the search text. This is working fine, and supplies a list as required for the user to choose from. However, if the user wants to change the search string how do I get the combo box to run the query again ( display the parameter entry box) without closing and opening the form?

The query sql is:

SELECT [Project Progress Details].ProjectID, [Project Progress Details].[Project List]
FROM [Project Progress Details]
WHERE ((([Project Progress Details].[Project List]) Like "*" & [Input search word] & "*"));

which I have put in the Row Source of the combo box.


Thanks


Liz

[Rabbit]

What/Where is this parameter entry box you're talking about? Is it on the same form? On a different form? An InputBox?

[ADezii]

Hi

I have a combo box on a form that populates from a parameter query, so the list only contains items that match the search text. This is working fine, and supplies a list as required for the user to choose from. However, if the user wants to change the search string how do I get the combo box to run the query again ( display the parameter entry box) without closing and opening the form?

The query sql is:

SELECT [Project Progress Details].ProjectID, [Project Progress Details].[Project List]
FROM [Project Progress Details]
WHERE ((([Project Progress Details].[Project List]) Like "*" & [Input search word] & "*"));

which I have put in the Row Source of the combo box.


Thanks


Liz

Assuming your Combo Box is named cboTest, just Requery the Combo Box and you will receive your Parameter Prompt again as in:

Me![cboTest].Requery

[NeoPa]

Liz, ADezii's answer should solve your problem perfectly.
Are you aware that you can code your SQL a bit more briefly (and use the standard quote) as :

SELECT ProjectID,[Project List]
FROM [Project Progress Details]
WHERE [Project List]) Like '*' & [Input search word] & '*'