I am kinda of at square one again. I am trying to update a field (remarks) for only a few records. The records that are in my query. My query is not updatable. In my form I am using that query in the main form and a another query based off the whole table. I am only pulling up the records that are in my main form query by linking them with the Parent/Child link.
The problem is when I update a field in my subform..it updates all the records in my table as my subform is based off the table. Please Help!!! Either I need to figure out how to make my query updatable or figure out how to make my subform only update those records and not the entire table.