Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2009

    Unanswered: Need Help with Form.......Please!!

    I have a form bound to one query. The form is distinct on name. There are several records for each person. When I update the form it's only updating the first record for that person. My fields are... name, ssn, dob, ph id and cost. The first 3 fields are the same for that specific person and the ph id is getting updated in the form. Cost is the only field that's different which creates many records for one person. I need the form to update all records when I enter the ph id. I've tried everything except VB coding. I think I may need to code a work around but don't know VB.


  2. #2
    Join Date
    Apr 2004
    metro Detroit
    It sounds like you have a relationship problem. If you post the SQL of your query, we can probably let you know if the table set up is wrong or if you can use a form/subform to take care of the problem.

Posting Permissions

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