Updating another record based on a current record

[willsth]

I have a form called "Project Details" and I am trying to link two records in the same table together.

The Table is "Projects". My records contain the following data:-

ID
Project Name (Numeric field)
LinkJob (Numeric Field)
etc....

Say I have 5 records in my file with Project Names - 123,124,125,126,127.
I have record 123 as my current record and I have a combo box which retrieves these Project Names and I update the field LinkJob with the appropriate linked-job e.g. 127. On AfterUpdate I wish to automatcally update the Record with Project Name 127 with the entry 123 in LinkJob, to complete the cross-reference.
I am trying to use currentDB.execute but am struggling with the syntax.

Any help with the code would be grateful

 

[PHV]

CurrentDb.Execute "UPDATE Projects SET LinkJob=" & Me![project name control] & " WHERE [Project Name]=" & Me![link job control]

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[willsth]

Sorted it thanks very much