Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
 Posted - 2006-07-17 : 07:24:16
|
| On my form i have a Combo box and a text box. If i select a month from the combo box i want the CountOfOrder to display in the text box, their will only be 12 rows in my query 12 month, and 12 CountOfOrder. each matching eachother so eg.100 Jan200 FedHow do i get the the count data form my query to display when i select a month from the drop down list. |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-07-17 : 08:03:36
|
| Way 1. When querying the Month(to be filled to the combo box), Select the count as well (and fill an array or a hidden combo box.Way 2. Pass another SQL Query, once the month is selected as Select CountOfOrder from Mytbl where [Month] = '" & cmbMonth.text & "'"Srinika |
 |
|
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
Posted - 2006-07-17 : 11:35:09
|
| I ended up doing it with a List box were i could use the single query, and i have the month a count beside eachother in the one box i think it looks better and then above them i've a text box with the total. |
|
|
|
|
|
|
Combo box