Hi there. I need to help with this DBCombo!!

Hi

I have a Chunktastic ADO control to access an Access 97 DB. I have an super chunky DBCombo control that is connected to the chunktastic ADO control. Trouble is, brothers and sisters, when you change the value in the DBCombo to something coooooler, and try to save the changes (using the swanky Update method) it complains, saying some tut about there not being enough base table info whatever the chunk that means!! ;)

So what gives? I'm using this code on the FormLoad (hey baby, that rhymes!)

Set cboInstructor.DataSource = Adodc1
Set cboInstructor.RowSource = Adodc2
cboInstructor.DataField = "InstructorID"
cboInstructor.BoundColumn = "InstructorID"
cboInstructor.ListField = "InstructorName"

Adodc1 is the ADO Control for the recordset, Adodc2 is the ADO Control that the DBCombo uses to get potential values to put in Adodc1.

Can anyone throw some light on the Chunkster?

Later man,

------------------
Regards,
The Chunkster

I appologise for my extrovert behaviour

Remeber, Mr Chunky is funky!

I recommend using the DataCombo control instead of the DBCombo when working with ADO. It is very similar to the DBCombo control and maybe it will help you.

Good Luck!!!