Show results of union query in combobox

[muddasirmunir]

I had two tables, one new customers and the other new suppliers.

Now I want to show all the customer and suppliers in one combo box.

I am using a recordset by coding

 
recordset1.open "select name from newcustomer union all select name from newsupplier" 
combobox1.rowsource = recordset1
combobox1.listfield = "name"
 

When I use a union clause it does not show the name in combo box. When I use only one table it works.

Remember I already made the name columns of both table as primary key so how can I show names from two or more tables in one combo box?

[Ali Rizwan]

Why don't you use a Do While loop to add contents in combo?

If you don't know the procedure I'll send it to you.

Eid Mubarik

>> ALI <<

[debasisdas]

Open separate recordsets and add to the combo in a loop.

[muddasirmunir]

i will try to make a loop

[Ali Rizwan]

i will try to make a loop

Adodc.Recordset.MoveFirst
 
Do While Not Adodc.Recordset.EOF
  Combo1.Additem (Adodc.Recordset.Fields (0))
  Adodc.Recordset.MoveNext
Loop

This is for Adodc. You can use this for adodb also.

Regards

>> ALI <<

[muddasirmunir]

first i made a view containg all the name of customers and
supplier and then make a adodc connection to it

and when i write the code its give me the error
"object variable or with block variable not set"

what wrong with it

Adodc.Recordset.MoveFirst
 
Do While Not Adodc.Recordset.EOF
 
Combo1.Additem ( Adodc.Recordset.Fields (0))
Adodc.Recordset.MoveNext
 
Loop

This is for Adodc u can use this for adodb also

Regards

>> ALI <<

[Ali Rizwan]

first i made a view containg all the name of customers and
supplier and then make a adodc connection to it

and when i write the code its give me the error
"object variable or with block variable not set"

what wrong with it

Replace Adodc with Adodc1.
OK

Regards

>> ALI <<

[muddasirmunir]

i had used the name adodc1 still its give error.
now , instead of using this
i had made a new table which contain all the name of
customers and suppliers
so this fulfill my task

Replace Adodc with Adodc1.
OK

Regards

>> ALI <<

[Ali Rizwan]

i had used the name adodc1 still its give error.
now , instead of using this
i had made a new table which contain all the name of
customers and suppliers
so this fulfill my task

Is the problem solved or not?
Or ill make an example of it?

Regards

>> ALI <<

[muddasirmunir]

problem is solved

thanks

Is the problem solved or not?
Or ill make an example of it?

Regards

>> ALI <<

[debasisdas]

We are glad to know that the problem is solved by help of our memebers.

Feel free to post further questions in the related forum only.