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