Fill in field on one table will update in another table

[bstale1]

Hello,

I am learning access as I go. I two tables and the two tables have a column with the same name and information. On my form, if I update information, I would like it update the other table. How do I go about doing this. (I am think AfterUpdate) I would appreciate any information

[ranman256]

make an update query.
this query will join the 2 tables on the common field,
then update the fields needed.

most everything is done with queries.

[bstale1]

I think I did not ask my question correctly. The fields are blank in both tables. If I data entry in my form, I would like for it to update into the other table.

[ssanfu]

This is not a normal thing to do because it violates the rules of normalization.

But to answer your question, I would use the FORM after update event to get the data from the controls on the form and execute an Append query that appends the data to the 2nd table.


But now you EDIT a record that has already been entered into both tables. When you save the edited form, the same record (with edits) is entered into the 2nd table again. Not what you want...

Now you have to have code to determine if the record being saved is an existing record or a new record. If a new record, append the data, if existing execute an Update query on the 2nd table.