Private Sub customername_Change() 
Set rs = cndb.Execute("select * from customer where cusname like '" & cusname.Text & "%'") 
Set Grid1.DataSource = rs 
Call hgrid 
End Sub 
Private Sub Form_Load() 
Set rscus = cndb.Execute("select * from customer where status=0 order by cuscode") 
Set Grid1.DataSource = rscus 
Call hgrid 
End Sub 
Sub hgrid() 
With Grid1 
    .TextMatrix(0, 1) = "id" 
    .TextMatrix(0, 2) = "name" 
    .ColWidth(0) = 200 
    .ColWidth(1) = 900 
    .ColAlignmentFixed(1) = 3 
    .ColAlignmentFixed(2) = 3 
End With 
End Sub 
Private Sub Grid1_DblClick() 
If ccc = 1 Then 
    frmsale.cusname.Text = Grid1.TextMatrix(Grid1.Row, 3) 
    ccc = 0 
    Unload Me 
    frmsale.tname.SetFocus 
End If 
End Sub 
 
 
  |