Reply to thread

Message: [QUOTE="Albert D. Kallal, post: 1916099"] No, not really, but then again, the sql has to be right in the first place. The problem with above that what record do you want from table Ed? In other words, you are trying to set a record in table Completed, and you are trying to get a value from table ED, but which value do you want from table ed? Further, you have to make sure the sql can distinguish between: The above sql would set all the values in the field of "name" to hello. So, what happens if you had a field called hello? In your case, you are trying to set all values to "[ED]![Name]". I suspect, that this would be of no use, and what you REALLY want is to fetched the value in the table called ed. However, as mentioned, you need to specify WHAT record in table ed you want. It is unlikely your above sql example runs ok in the query builder (get your code working in the query builder first, and THEN try pasting it into your code. If for each record in table Completed, there is a single record from table ED that has the same keyid, then you can do a join, and then run a update. So, you need to identify what record from Completed you want to update (or perhaps all records). And, you need to identity, or choose what value you want from table ED. [/QUOTE]