I NEED HELP USING DLOOKUP ON A ACCESS SUBFORM.
IN THE SUBFORM I HAVE THE FOLLOWING:
SOR CODE (FIELD SAVED IN TABLE JOB COSTS)
UNIT (TEXT BOX)
RATE (TEXT BOX)
WORK DESC. (TEXT BOX)
WHEN THE SOR CODE IS ENTERED I NEED THE UNIT AND RATE TO POPULATE, BY LOOKING UP VALUES IN TABLE SOR CODES
THE TABLES THAT CONTAINS THE DATA IS CALLED SOR CODES.
THE MAIN FORM IS CALLED JOB DETAILS
THE SUBFORM IS CALLED JOB COSTS
CAN SOMEONE HELP PLEASE.
I HAVE TRIED
=DLookUp("[UNIT]","[SOR CODES]","[SOR CODE]='" & [SOR CODE])
AND I GET A ERROR?
IN THE SUBFORM I HAVE THE FOLLOWING:
SOR CODE (FIELD SAVED IN TABLE JOB COSTS)
UNIT (TEXT BOX)
RATE (TEXT BOX)
WORK DESC. (TEXT BOX)
WHEN THE SOR CODE IS ENTERED I NEED THE UNIT AND RATE TO POPULATE, BY LOOKING UP VALUES IN TABLE SOR CODES
THE TABLES THAT CONTAINS THE DATA IS CALLED SOR CODES.
THE MAIN FORM IS CALLED JOB DETAILS
THE SUBFORM IS CALLED JOB COSTS
CAN SOMEONE HELP PLEASE.
I HAVE TRIED
=DLookUp("[UNIT]","[SOR CODES]","[SOR CODE]='" & [SOR CODE])
AND I GET A ERROR?