I have a form that uses a subform as well, I need to have a field in the subform not only update the table it is attached to but also update the same field in another table.

This sounds like a structural problem. I can think of no reason for duplicating a field in two different tables (other than a foreign key). What exactly are you trying to do? How do you know which record should be updated?

it is a design problem, but I do not have time to redesign the whole thing.Basicly I have a form that a sales rep enters info, and the info in turns put data in the lot table, My task was to build another form for a differant department that will use the lot table to fill in the basic info, but also uses a subform to write data to another table, all the reports are written against the lot table, and I will be write new reports, however I need to have the data in both tables. The reason I did not just add all the extra fields to the lot table (which qwas my first choice) and be done with it, was because ofthe 255 field limit in access. To get around that, I used the lot table for the basic info, and used a new table "room" for the new info, there are however overlaping fields that need to both be updated.

The question is ...

Do you have the time now to fix the application or do you have the time latter ...
A bad structiure is not good to create an application around ...

I recommend you fix your structure now or you will more than likely have many more problems with your design ...

RDH

impossiable, not my design. I would be better off creating a whole new database correctly. I do not have the time to try and figure out how the other person did what he did and he no longer works for us

Well then you can't expect us to add to the misery and bad design by attempting to fix problems that should not be in the first place ...

RDH

no I didn't expect anything, I was only asking for help, and if it was possiable, if not tell me and I will move on, if it is possiable all I ask is how, I am not an access wizard

Why do you feel you can't take a few extra minutes to get the structure correct? If you're running into the 255 field limit then you definitely have repeating groups and mixed entities. It may be possible to re-structure in the same amount of time it would take to build a workaround to your problem.