Hi all..
For some reason I cannot get this to work and it is driving me crazy. Here is what I have. A combo box on a form (frmTest) that is drawing from a table, tblInvestigator. This part works.
I then have a query that has the following line of code in it to draw from the form.
The query works fine when I run the query a pop up box asks me to enter something into the box and the parameter is queing me from [Forms]![frmtest]![cboInv]. When I type in a name I get the desired results. So I know this part is working.
When I try to run a test using the query and the form it doesn't work. I use the drop down list cboVieInv to select a person. Then I go back to the query and run it.. I don't get any results.
I have attached a sample of what I am talking about.
Thanks
R~
For some reason I cannot get this to work and it is driving me crazy. Here is what I have. A combo box on a form (frmTest) that is drawing from a table, tblInvestigator. This part works.
I then have a query that has the following line of code in it to draw from the form.
Code:
[Forms]![frmtest]![cboInv]
The query works fine when I run the query a pop up box asks me to enter something into the box and the parameter is queing me from [Forms]![frmtest]![cboInv]. When I type in a name I get the desired results. So I know this part is working.
When I try to run a test using the query and the form it doesn't work. I use the drop down list cboVieInv to select a person. Then I go back to the query and run it.. I don't get any results.
I have attached a sample of what I am talking about.
Thanks
R~