DO I not get it or am I right Combo Box in a Query

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

I am trying to run a query to search a table for Chemical Names and ouput the
records and all fields associated with that Chemical. I want to have a Comco
Box so that the User doesn't have to type in the names as they can be
complex. I have used a parameter Query with the criteria set to

=[Forms]![frmFormWithComboBox]![cboComboBoxName]

When I run the QUERY I get a Dialog Box that asks to enter the parameter.
The dialog box also displays the
=[Forms]![frmFormWithComboBox]![cboComboBoxName] But no Combo Box.

When I run the Form it seems to run OK. I get the Combo Box. I Can select
a name and the query appears, seemingly correct.

I thought that the query would run the form. Meaning when I double clicked
the Query the Combo Box woud be used to enter the parameter, in this case the
Chenical Name. This appears to run the other way around the Form runs the
Query.

Confused!!

Bill
 
The query can't open the form to find the combo box, the form has
to already be open when the query is run.
 
Thanks! I guess I've been trying to get this to run for days and it was OK
all along. Oh well.

Bill

Beetle said:
The query can't open the form to find the combo box, the form has
to already be open when the query is run.
--
_________

Sean Bailey


Bill said:
I am trying to run a query to search a table for Chemical Names and ouput the
records and all fields associated with that Chemical. I want to have a Comco
Box so that the User doesn't have to type in the names as they can be
complex. I have used a parameter Query with the criteria set to

=[Forms]![frmFormWithComboBox]![cboComboBoxName]

When I run the QUERY I get a Dialog Box that asks to enter the parameter.
The dialog box also displays the
=[Forms]![frmFormWithComboBox]![cboComboBoxName] But no Combo Box.

When I run the Form it seems to run OK. I get the Combo Box. I Can select
a name and the query appears, seemingly correct.

I thought that the query would run the form. Meaning when I double clicked
the Query the Combo Box woud be used to enter the parameter, in this case the
Chenical Name. This appears to run the other way around the Form runs the
Query.

Confused!!

Bill
Click to expand...
Click to expand...
 
Back
Top