how to set the rowsource for a chart using viusal basic code?

G

ge liu

Hi,

Could anyone tell me how to set the rowsource for a chart
in an access report using visual basic code?

I used this type of code:

me.controls("graph3").rowsource="select Jan03, Feb03,
Mar03 from sales_table"

But this does not work. The access does not recognize
rowsource as a properties for my chart "graph3",
eventhough it is listed in the property box. Could anyone
tell me how to solve this?

Thanks

Ge
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to set the rowsource in a chart control using visual basic code 4
Set Rowsource property for Chart Control using VB code 7
Error setting Rowsource using VBA for Chart 3
Chart RowSource problem in Report 1
VBA to set the font size for the axes of a bar chart 1
setting rowsource for chart control using Basic code 0
How to change ListBox RowSource programatically 1
How To Set The RowSource property of a combo box via code 2

Top