I think i am doing something wrong here. I get the result i want using a dblookupcombobox but i think i should be using dbcombobox instead and it is not working.
I have a database with one table called process. The table has 2 records. each record has 2 fields. ProcessNo and Processname.
If i setup the dbcombobox with the datasource pointing to datasourceprocess and the fieldname set to processname, it will only display one record when i click on the arrow and not both.
If i setup a DBlookupcombobox and only set the listsource this time and leave the datasource empty to avoid circular reference, I can see both records when i click on the arrow.
I have a feeling i should be using dbcombobox.
What am i doing wrong?
Thanks.
Pierrotsc.
I have a database with one table called process. The table has 2 records. each record has 2 fields. ProcessNo and Processname.
If i setup the dbcombobox with the datasource pointing to datasourceprocess and the fieldname set to processname, it will only display one record when i click on the arrow and not both.
If i setup a DBlookupcombobox and only set the listsource this time and leave the datasource empty to avoid circular reference, I can see both records when i click on the arrow.
I have a feeling i should be using dbcombobox.
What am i doing wrong?
Thanks.
Pierrotsc.