MS Access

Posted on 2012-09-22
Last Modified: 2012-10-19
This is rather simple question but I was not able to find an example on this... so the setup is rather basic...

I have one table called Client and other Call (their are linked by ClientID), 1 to Many.

I want to have one form that has client info on it and then have ability to "make" new calls which would write to calls table only info related to a call but still "linked" by the one specific clientID field.. I tried to use quaries but that only links one to one... and I could not find a way to make multiple records while still staying on the same clientID... please advise or if you can point me to examples I would greatly appreciate.

Thank you and have a great day!
Question by:TechMan4Ever
    LVL 65

    Accepted Solution

    Based on your description I recommend...
    A main form that has your Client info, with Client table as recordsource
    A subform on that main form that would be your Call info, with Call table as recordsource.  In Form Design, subform control make sure your Link Child Fields-LinkMasterField is ClientID.  If you envision other 1:M subforms on this main form (say payment history, client status history, whatever), you can use a tab control and put the Call subform on one tab, the others on others.  

    Author Comment

    Thank you, now how would I make it so that it always open a new record source with clientid already inserted into the subform? I don't want to see other calls already made, just insert this new one... thank you for your help!

    Author Comment

    basically my question is how to send new record command to a subform..... thx.
    LVL 44

    Expert Comment

    by:Martin Liss
    This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
    In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
    This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now