Coffeehouse Thread

6 posts

How to autofill information in Form?

Back to Forum: Coffeehouse
  • Eigenvector

    Hi,

    I have 10 fields in my Invoice and I want this form will automatically fetch data from Consultant Table.

    For exmaple, In Invoice Form If I have selected the Constultant ID then rest of the information like First Name , Last Name, Company etc. will automatically get updated in form instantly and I can save and enter new invoice.

    Regards
    Eigen.

  • DeathBy​VisualStudio

    Based on the details you included in your question I can only suggest you check here.

    If we all believed in unicorns and fairies the world would be a better place.
    Last modified
  • GoddersUK

    @DeathByVisualStudio: Because browser add ons are exactly what he's looking for Perplexed

  • 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.

  • DeathBy​VisualStudio

    @Eigenvector: Unfortunately even with the details you've provided there is no single answer.

    I suggest you start with this walk-through on Connecting to Data in an Access Database. This will show you how to make your MS Access database a datasource in your Visual Studio project. Then use the Windows Forms Data Binding guide to learn how to wire up your datasource to your forms.

    These are all MSDN reference materials. Learn to search them and search them well.

     

  • DeathBy​VisualStudio

    , GoddersUK wrote

    @DeathByVisualStudio: Because browser add ons are exactly what he's looking for Perplexed

    Just working with the data provided...  Tongue Out

Comments closed

Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums, or Contact Us and let us know.