Thanks again. I tried If DLookup(myID, "RecordsT", [Table!RecordsT!EntryID]) Then rs.Update End If But got an error message needing a debug. (myID is the temporary field I am trying to add in the primary field, EntryID, in the table RecordsT) Any further suggestion would be greatly appreciated. David
Reply from Richard Rost:
All of your DLOOKUP parameters need to be in quotes, and your equation for the criteria makes no sense. YOu just have a single field there.
X = DLOOKUP("CustomerID","CustomerT","CustomerID=" & Forms!MyForm!SomeField)
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
