Good Day, I try to develop an access 2010 Forms that contains 1 or 2 charts. So my problem is, in my form i have 1 combobox and 5 unbound textbox. Inside Event OnChange combobox, there is function DCount that will setup value to the 5 unbound textbox. until this point, the 5 unbound textbox is have its value. now i would like to create a chart that value are based on the 5 unbound text. How can i accomplish this ? i see in many articles, a chart row source is link to a cross tab query. any help or idea would be very appreciated.
for example, i create 1 table that consist of Customer_ID, Slag, Poros, IF, LOP, Crack, Root. type data is all Number (Integer). my table name is book_tble. then i create a form and put 1 combobox (control source : Customer_ID), 6 unbound textbox (control source : Slag, Poros, IF, LOP, crack, root). on combobox event AfterUpdate, i put this code :
so, it will be like this. if user pick from combobox, ex: User-001 then 6 unbound textbox will use function DCount and result will be 1,1,1,1,1,1. I already done until this part. what i want is, if i add 1 button named chart, user can see a chart that get value from those 6 unbound text. i hope you can understand from my example. any help or idea would be very appreciated.
Sorry no, I can read what you write but I can't image how the graph should look like, make one in Excel with the values from Access and post a print screen.
One idea is to put the values from the text boxes into a temporary table and base the graph on that table.
@JHB thanks for your reply. i already solved the problem. i really a newbie in this access 2010. so i create a new table and put the value to the table from 6 textbox (you can see from my old post). and based on the table, i create a chart. anyway, thanks for your help.
