Can someone please tell me what is wrong with this before I throw this laptop out of the window...
Cur_Candidate_Status = DLookup("Candidate_Status_Long", "qry_Candidate_Status2", "Candidate_ID = " & Forms![splitform_RRARs_Approved]![frm_Candidates].Form!txt_Candidate_ID)
The Form names are...