linking of combo box value to the command box

  • Thread starter Thread starter angshuman shome via AccessMonster.com
  • Start date Start date
A

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.
 
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.
Click to expand...

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]
 
Back
Top