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...