Results 1 to 2 of 2

Thread: vb6 database

  1. #1
    Join Date
    Oct 2003
    Posts
    10

    Unanswered: vb6 database

    hi
    i m looking for a code where ,data is added in to the combo box from a table , when i click on each item in the combo box it should display information in to text boxes using other table.for ex:i have two tables namely products and sales in the acces database . the products information should filled into the combo box when i click on each product listing it should display the sales information in the text boxes.please help me by sending the code for this ASAP!!!, as i have the project deadline approaching.thanks.

  2. #2
    Join Date
    Jul 2003
    Location
    Amsterdam, Nederland
    Posts
    450

    Smile a b c ... 1 2 3

    i hope you can set the combo box yourself ???

    if that is done in the sub combobox_change write the code


    rsSale.open ("SELECT * FROM Sales Where ProductName like " & cobobox.boundtext)


    after this is done under the openstatement set
    if rsSale.recordcount >0 then
    with FrmSale
    .txtsalesID.text = rsSale.SalesID
    .txtSalesPrice =rsSale.SalesPrice
    ect ect
    FrmSale.Show
    end if

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •