linking of combo box value to the command box

[angshuman shome via AccessMonster.com]

I have
From - FORM1
Table - ID(field -ID), Index, Query3
Join Query - Query3 (on table Index and Address)

Now
In the Form,
A combo box which is linked to table - ID.
A command box which is linked to Query3

When I click on the command box, it aks me the input parameter.
If I give a value to it, query is run and result is displayed.

But, I want when I select a value from the combo box.
It should be automatically passed as input parameter to the query.
And when I click on the command box, it should not ask me for input parameter. But give me the result, based on the value selected on the combo box.

Please suggest me, how can I do so.

 

[John Vinson]

Now
In the Form,
A combo box which is linked to table - ID.
A command box which is linked to Query3

When I click on the command box, it aks me the input parameter.
If I give a value to it, query is run and result is displayed.

The input parameter should be of the format

[Forms]![NameOfYourForm]![NameOfTheComboBox]

I don't know the name of your form nor do I know the name of your
combo box, substitute them for this example.

John W. Vinson[MVP]