S
Stockman
Hi , I'm building a stock database and my form has a list box and 2 charts -
the list box for my parameter query to show the stock symbols prices, volume
date:
SELECT [2005 Data].Symbol, [2005 Data].High, [2005 Data].Low, [2005
Data].Close, [2005 Data].Volume, [2005 Data].Date, [2005 Data].[Close Bid],
[2005 Data].[Close Ask] FROM [2005 Data] WHERE ((([2005 Data].Symbol)=[Enter
Symbol])) ORDER BY [2005 Data].Date DESC;
So I have 2 questions: How do I set up the form so I can click on a command
button, it runs the parameter query ( I enter the symbol ) and it shows the
query results in the list box. When the form is open, my command button opens
a separate datasheet with the query results but doesnt update the list box.
Next question - how do I then use the same query to select only the close
price and date columns for chart one, then select only volume and date
columns to draw chart 2. The whole concept Im going for is to be prompted to
enter the symbol, it then updates the list box, then goes to chart 1, draws
the chart, then to chart 2 and draws it all in one step. Comments and coding
would be appreciated. Thanks!
the list box for my parameter query to show the stock symbols prices, volume
date:
SELECT [2005 Data].Symbol, [2005 Data].High, [2005 Data].Low, [2005
Data].Close, [2005 Data].Volume, [2005 Data].Date, [2005 Data].[Close Bid],
[2005 Data].[Close Ask] FROM [2005 Data] WHERE ((([2005 Data].Symbol)=[Enter
Symbol])) ORDER BY [2005 Data].Date DESC;
So I have 2 questions: How do I set up the form so I can click on a command
button, it runs the parameter query ( I enter the symbol ) and it shows the
query results in the list box. When the form is open, my command button opens
a separate datasheet with the query results but doesnt update the list box.
Next question - how do I then use the same query to select only the close
price and date columns for chart one, then select only volume and date
columns to draw chart 2. The whole concept Im going for is to be prompted to
enter the symbol, it then updates the list box, then goes to chart 1, draws
the chart, then to chart 2 and draws it all in one step. Comments and coding
would be appreciated. Thanks!