hi
select cobobox and in right you will see the properties
1/datasource make its value the table in dataset you want
2/ ValueMember make its value the coulmn name (name of custeomer)

when your form load you fill dataset

now the list of comboBox has the names of ur customers

i hope this help

hi and thanks for your reply. however i have been able to do that fill. my query is this.

I have 3 textboxes on my form.
when i select the item from the combobox i need the 3 textboxes to be filled with the data corresponding to that field. ( what i'm trying to say is that i have a table in macces with 4 rows, one of them is the field chosen in the combobox. now when i select the item i want the textboxes to display the latter of the record)

thanks
lukis

hi:cheesy:
i used dataset and dataadptor for display the other data in text box
the sql query will be like this


then douple click in combobox and write this code (douple click means the code will excute when user select value )



i hope this what u want

manal

thanks. listen i found this code but it's in c#... i need something that is exactly like this....but in vb.net 2003......

http://www.codeproject.com/csharp/combobox.asp

please help me thank you for your co-operation

guys imagine i have this table

Rest_type Rest_name Tel Location
----------- ------------ --- ----------

ala carte del pinto 2345546 Dublin
pizzeria francesco's 3455667 Rome




now i have a form with a combobox (cbRests), and 2 textboxes (txtType, txtTel)

i have been able to include the Rest_name in the combobox but i need to fill in the textboxes with the relevant info...ex

when i select del pinto from the combobox, i want the textboxes to display ala carte and 2345546....how can i do that......in code please as i have no idea on how to do that.... thank you very much...your help is very much needed here