Is it possible to update 2 tables

[TIDMAN]

in a single DB from a form in the same DB?, can anyone tell me how to do it please?

Thanks in advance.

TIDMAN

 

[pcEars]

Bad practice to store the same data in 2 different tables. Consider redesigning your tables.

 

[GumbyD]

Tidman -

Is there a common key or keys between the two tables? You may be able to put both the tables into a query and use the query as the form record source. If the query is updatable then when you save the data on the form both of the tables will get the updates. If that is not what you are asking you may want to provide a few more details.

GumbyD