i am having real trouble getting a data combo to work in my application, having followed a number of tutorials, I still cant get it to work, can anyone see what I am doing wrong.

on startup of my form I set two datacontrols

Set Adodc_Users.Recordset = GetRecordset("Select * from [User]")
Set Adodc_JobTitles.Recordset = GetRecordset("Select * from JobTitle")

on my form i have a datacombo and i set the following properties
DataCombo1.DataField = "JobTitleID"
DataCombo1.BoundColumn = "JobTitleID"
DataCombo1.ListField = "JobTitle"
Set DataCombo1.RowSource = adodc_jobTitles.recordset
Set DataCombo1.DataSource = Adodc_Users.Recordset

when i run the form the datacombo is blank !!! has anyone any idea why the properties wont set?

many Thanks

hi there.. something is messed up here.. but I don't remember enough to do it by heart...

why the datasource and the rowsource are diferent?? shouldn't be the same?

does datafield exist in the datasource?? why use the bound column if you are using the list field? also does the boundcolumn exists in the 2 tables??

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

To be honest, i have lost myself with all this datagrid stuff, at the end of the day what i am trying to do is create a datagrid, have a combo box in it so that rather than users having to know the ID of the product, they can just select the product, which will update the underlying grid, then have a way of updating, inserting and deleteing into a grid. I spend the best part of a week searching for any type of turorial on datagrids on the net, but cant find anything, so would appriectiat if any one knows of a good datagrid turorial.