G
Guest
How do I run all 3 queries one after the other with one click of a command
button which pulls data from the same table but select different columns to
display in different parts of the form: example:
Table1 has these columns: Symbol High Low Close Volume Date
1. 1st query selects all the above columns to display in list box 1 ( or
combo box1? ) where your search criteria is by symbol eg. XYZ ( mine is set
up as a parameter query )
2. 2nd query selects close and date only for symbol XYZ and displays it in
chart 1
3. 3rd query selects volume and date only for symbol XYZ and displays it in
chart 2
Im really struggling with the design, suggestions and how to code my form to
do this would be appreciated.
button which pulls data from the same table but select different columns to
display in different parts of the form: example:
Table1 has these columns: Symbol High Low Close Volume Date
1. 1st query selects all the above columns to display in list box 1 ( or
combo box1? ) where your search criteria is by symbol eg. XYZ ( mine is set
up as a parameter query )
2. 2nd query selects close and date only for symbol XYZ and displays it in
chart 1
3. 3rd query selects volume and date only for symbol XYZ and displays it in
chart 2
Im really struggling with the design, suggestions and how to code my form to
do this would be appreciated.