Coffeehouse Post

Single Post Permalink

View Thread: How to autofill information in Form?
  • User profile image
    Eigenvector

    I am trying to elobrate more:

    I am making application using VS in 2003.

    I have create 2 Tables, a) Invoice b) Consultant in MS Access.
    I have created 2 Form for above tables usine Visual Studio 2003.

    I have created both the below forms in VS 2003, All i need to connect them to associated table in MS access.. Pls suggest for that too..
    Fields in Invoice Table:

    1. First Name
    2. Last Name
    3. Company
    4. Invoice Approver
    5. ProjectID
    6. Description

    Fields in Consultant Table:

    1. First Name
    2. Last Name
    3. Company
    4. Manager
    5. ProjectID

    I want when I select ProjectID in Consultant form it will instantly display or update the FirstName, LastName, Company, Description and Manager which is saved in Invoice table.

    Hope I am clear, let me know if anything is needed.

    Regards

    Eigen.