i have used your coding, jzwp11, with minor adjustments. it seems to be working but i still get an error now another error below is the complete code and the error i get.
Run-time Error '3164': Field cannot be updated
Not sure if it helps but this is on a onclick command of a listbox
Code:
DoCmd.OpenForm "Call Info"
Forms![Call Info]![fnameTXT].Value = Forms![Customer Support Department]![fnametb].Value
Forms![Call Info]![lnameTXT].Value = Forms![Customer Support Department]![lnametb].Value
Forms![Call Info]![phonetxt].Value = Forms![Customer Support Department]![CallSearchResults].Column(2)
Forms![Call Info]![DateCallTXT].Value = Forms![Customer Support Department]![CallSearchResults].Column(0)
Forms![Call Info]![TimeCallTXT].Value = Forms![Customer Support Department]![CallSearchResults].Column(1)
ID = DLookup("[ID]", "[Call Information]", "[Call Date] =#" & Forms![Call Info]![DateCallTXT].Value & "# AND [Time Called] = #" & Forms![Call Info]![TimeCallTXT].Value & "# AND [Phone Number] ='" & Forms![Call Info]![phonetxt].Value & "'")
Forms![Call Info]![DepartmentTXT].Value = DLookup("[Department]", "Call Information", "[ID] = ID.value")
Forms![Call Info]![Remarkstxt].Value = DLookup("[Remarks]", "Call Information", "[ID] = ID.value")