Starfleet captains are like children. They want everything right now and they want it their way. But the secret is to give them only what they need, not what they want.
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.
