Hi All,
I'm probably being stupid (new to this) but is there a way to select a query field from a combobox?
I have a Table (History)that contains
Record_date , Comp1 , Comp2 , Comp3 etc
1/1/13 , 1234, 2345, 3456 etc
2/1/13 , 1214, 2355, 3466 etc
Basically a table of values for each Company for a set date.
If I select my field as Comp1, comp2 etc in my query it will return the values by date for the selected field. Which is what I need.
I've created a form that has a combo with a dropdown of all the companies but I can't get the field to use the selected value.
I run the query from my form After Update and my query field is an expression
Expr1: History.[Forms]![Chart]![Combo3].[AfterUpdate]
The idea being that I select a company on my dropdown that runs a query giving me a history of prices that will be plotted as a simple line chart.
Sure its very simple but I just can't seem to find what I'm doing wrong/ example of it working.
Thanks,
EL-d
I'm probably being stupid (new to this) but is there a way to select a query field from a combobox?
I have a Table (History)that contains
Record_date , Comp1 , Comp2 , Comp3 etc
1/1/13 , 1234, 2345, 3456 etc
2/1/13 , 1214, 2355, 3466 etc
Basically a table of values for each Company for a set date.
If I select my field as Comp1, comp2 etc in my query it will return the values by date for the selected field. Which is what I need.
I've created a form that has a combo with a dropdown of all the companies but I can't get the field to use the selected value.
I run the query from my form After Update and my query field is an expression
Expr1: History.[Forms]![Chart]![Combo3].[AfterUpdate]
The idea being that I select a company on my dropdown that runs a query giving me a history of prices that will be plotted as a simple line chart.
Sure its very simple but I just can't seem to find what I'm doing wrong/ example of it working.
Thanks,
EL-d