Results 1 to 3 of 3
  1. #1
    skatiekat is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Nov 2012
    Posts
    2

    Exclamation Data in subform records repeating


    Hello, I need help, I've been working on this for days and haven't figured it out. In the main form for each of my clients, I wanted to be able to track each time I contacted them or they contacted me. So, I created a new table and subform specifically for this. Then I put the subform into the main form. The problem is: say, I input data into the subform for Client A... the same input shows up for all my clients. How do I make the subform be specific to each client, and not repeat for every client?
    Thank you!

  2. #2
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    Is the Main Form and Subform linked with a common Field, such as a ClientID Field, in the Subform's 'Link Master Field/Link Child Fields' Property?

    It almost sounds as if the Fields in the Subform are not Bound to Fields in the underlying Table.

    If, for ClientA, you enter

    "ClientA is a Dweeb!"

    and for ClientB you enter

    "ClientB is cool!"

    when you move to ClientC do you see

    "ClientA is a Dweeb!"
    "ClientB is cool!"

    or simply

    "ClientB is cool!?"

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    skatiekat is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Nov 2012
    Posts
    2
    Linq... thank you! Your answer made me think about linking differently, my change in perspective allowed me to solve my problem, so thank you so much!! Another question for you... is there a way to change records from ascending to descending by date? And also to put the new record creator at the top instead of the bottom?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 05-02-2012, 09:16 PM
  2. Replies: 12
    Last Post: 08-30-2011, 03:36 PM
  3. Replies: 7
    Last Post: 07-15-2011, 01:58 PM
  4. Repeating data in a field for a new record
    By NOTLguy in forum Forms
    Replies: 3
    Last Post: 10-29-2010, 07:27 PM
  5. Repeating Records
    By windwardmi in forum Reports
    Replies: 13
    Last Post: 05-22-2010, 02:54 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums