----- Original Message -----
Sent: Tuesday, December 06, 2005 11:50
AM
Subject: [Programmer-VB] Tanya, pilih
list field Combo Box, isi textbox
mo tanya nich.
gw pengen menampilkan "janis_barang" berdasarkan "kode_barang" yang di
pilih pada combobox...
untuk menampilkan "kode_barang" pada combobox udah udah solve
tapi setiap di pilih "Jnies_barang" belum muncul
code:
Sub Ganti_Label()
Dim strSQLjenis As
String
Set rsMJenisBarang1 = New
ADODB.Recordset
strSQLjenis = "select * from
MJenisBarang where Jns_Kode = '" & Trim(ComboKodeJenis.Text) & "' "
rsMJenisBarang1.Open strSQLjenis, Con_DB
With
rsMJenisBarang1
Text1.Text =
Trim(!jns_nama)
End With
End Sub
Sub Isi_ComboJenis()
Dim strSQLjenis As String
Set
rsMJenisBarang = New ADODB.Recordset
strSQLjenis =
"select * from MJenisBarang"
rsMJenisBarang.Open
strSQLjenis, Con_DB
With rsMJenisBarang
.MoveFirst
While Not
.EOF
ComboKodeJenis.AddItem
rsMJenisBarang("Jns_kode")
.MoveNext
Wend
End
With
End Sub
Private Sub Form_load()
Call isi_comboJenis
End
Sub
Private Sub ComboKodeJenis_Change()
Call
Ganti_Label
End Sub
kira2 masih kurang dimana nya ya...
TIA
--
Regards,
Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]
YAHOO! GROUPS LINKS