HI
i am new in VB programming.
i made data base in MS Access 2000 and i use ADO to connect the database.
i want to use combobox but my combobox shows only 1 value not all and also give error of unrecognized datadbase.
i use this code for show values in combobox.
Set Rs = Db.OpenRecordset("source"
'Rs.MoveFirst
'Do Until Rs.EOF
'comsource.AddItem Rs.Fields("sourcename"
'Rs.MoveNext
'Loop
'Db.Close
but it is not working.
another problem is that.
i want connect 1 combobox with my 1 database table (source)field and another combobox with other table destination (field).
means i select 1 item from 1 combo box and another from another combobox then press the button so it will show the result which is stored in my third database table (result).
i want help in code.
plz reply soon
i am new in VB programming.
i made data base in MS Access 2000 and i use ADO to connect the database.
i want to use combobox but my combobox shows only 1 value not all and also give error of unrecognized datadbase.
i use this code for show values in combobox.
Set Rs = Db.OpenRecordset("source"
'Rs.MoveFirst
'Do Until Rs.EOF
'comsource.AddItem Rs.Fields("sourcename"
'Rs.MoveNext
'Loop
'Db.Close
but it is not working.
another problem is that.
i want connect 1 combobox with my 1 database table (source)field and another combobox with other table destination (field).
means i select 1 item from 1 combo box and another from another combobox then press the button so it will show the result which is stored in my third database table (result).
i want help in code.
plz reply soon