Update in seperate table

[vCallNSPF]

I have two tables

one is ClientDetails
the other is ClientContactDetails

in the form for ClientContactDetails i have a last edited field called UpdateDate. i have a button on the form which has a save form function. it also has an on click function "me.UpdateDate = Date()" which updates the UpdateDate field to todays date.

The problem is, when i click the save button i also want it to update an UpdateDate field in the ClientDetails table, how to i change the on click function to update in the other table aswell?

[Rainlover]

Why would you change the Last Update in a Table where nothing has been updated?

[vCallNSPF]

Why would you change the Last Update in a Table where nothing has been updated?

I have a report at the end which gives the illusion that the two tables are the same.

do you know how to do it

technically i dont need it to update the UpdateDate field in the ClientContactDetails table, since the report only shows the UpdateDate field from the ClientDetails table

[Rainlover]

The ClientContactDetails Table may have several records. (At a guess)

Would you update all these.

Could be a bit misleading.

But you could run an Update Query to update all those records. But I don't like it.

[vCallNSPF]

The ClientContactDetails Table may have several records. (At a guess)

Would you update all these.

Could be a bit misleading.

But you could run an Update Query to update all those records. But I don't like it.

Yeah it does have several records.

And I want the date updated for any changes in any of the records.

But all that is beside the point, i basically just need the code because its too hard to explain WHY. wouldnt it be a variation of "me.UpdateDate = Date()". I just need the right syntax to include a tablename aswell.

[Rainlover]

No it is not a Variation of me.update.

You are addressing a Different Table and various records within that Table.

You need an UPDATE Query that runs on I would think the Before Update Event of the Record.

I must say that I do not agree with what you are doing as you can always get the Date from the Parent table.

[vCallNSPF]

No it is not a Variation of me.update.

You are addressing a Different Table and various records within that Table.

You need an UPDATE Query that runs on I would think the Before Update Event of the Record.

I must say that I do not agree with what you are doing as you can always get the Date from the Parent table.

the ClientDetails table only has one record because its only 1 client, there will never be more than 1 client.

i just need a button on the form for the ClientContactDetails that will change the date in the single UpdateDate field of the ClientDetails table

[Rainlover]

If you post a cut down version of what you have, Just those Two tables and the Form, all with dummy data, then I will write something for you.

Compact and Repair first and Zip it.

[maximus]

I agree that an update query is required and it can be done by using vb code. Use this

Dim SQL As String

SQL = "UPDATE Employees " & _
"SET Employees.Title = 'Regional Sales Manager' " & _
"WHERE Employees.Title = 'Sales Manager'"

CurrentDb.Execute SQL, dbFailOnError

I am explaining the code
SQL = "UPDATE Name of the table u want to update " & _
"SET Name of the table u want to update .Field you want to update = 'Value you want' " & _
"WHERE Name of the table u want to update.Feild to which u want to attach the criteria = 'Criteria'"

remember this wil update all the related record and i completely agree with rain lover on this point.