hello,

i have two combo box. the first combobox (cbtype.text) was filled from dataset, now the data on the next combobox will depends on the data from the first combo box. my data will come from access thru dsn


heres my sql for the 2nd combo box
SELECT MODEL, type, ord
FROM MODEL
where type=cbtype.text


but it is not working, any help please

well it should be:

"SELECT Model, type, ord FROM Models WHERE type = '" + cbtype.text + "'"

as well as this, looks like you are creating a filtered drop down combobox correct? if so, you maybe better of filling all the required info in a dataset and filter that than to query SQL every time as it can be expensive

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=786157&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=868748&SiteID=1

well it should be:

"SELECT Model, type, ord FROM Models WHERE type = '" + cbtype.text + "'"

as well as this, looks like you are creating a filtered drop down combobox correct? if so, you maybe better of filling all the required info in a dataset and filter that than to query SQL every time as it can be expensive

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=786157&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=868748&SiteID=1

hello, i already filled my first combobox with dataset now on my second combobox, i followed your suggestion but still nothing appears.

i followed your link but if possible i would like to fill my 2nd combobox with almost the same as my 1st combo box. less codes and just insert my sql on the dataset query builder.

here's my query now on my dataset
SELECT MODEL, type, ord
FROM MODEL
where type=?


i have this on my selected index change

Me.MODELTableAdapter.Fill(Me.ModelDataSet1.MODEL, CbType.Text)

not sure I follow exactly. what are you trying to fill in the 2nd combobox and how are you doing this?

hello,

i have this on my form load event to fill my first combo box (CbType.Text)

Me.Truck_typeTableAdapter.Fill(Me.TruckTYpeDataSet1.truck_type)


then on my CbType selected index changed

Me.MODELTableAdapter.Fill(Me.ModelDataSet1.MODEL, "CbType.Text")


inside the ModelDataSet1 i have these sql

SELECT MODEL, type, ord
FROM MODEL
where type=?

in which my question mark was supposed to be replaced by CbTYpe.text
i'm having these error

Error[HY104][Microsoft][ODBC Microsoft Access Driver]Invalid Precision Value

oh and by the way i'm using microsoft odbc dsn to connect to data source

sir,

i've made a printscreen of the error

http://www.geocities.com/corvusph/error1.gif

thanks

Were you able to get around the problem? I am also using ODBC to connect to my database. I get results in the query builder just fine, but when I go to Preview Data, Iget the same error:

ERROR [HY104][Microsoft][ODBC Microsoft Access Driver]Invalid Precision Value

Is it on the database end or my dataset end? Why are records returned in the Query Builder, but not when iIwant to Preview the data?

Thanks in Advance!