First, I am aware that dlookup is not the most effecient method to my approach, but it's what I know.
Second, my goal is to be able to have access print out the form as if I were printing a document from Word, with the information called from the dlookup function.
My problem:
I can't seem to figure out why all the dlookup codes work fine on frmNew_Form7C_review, but not all work on rptForm7C. If this matters, the report was created by saving the form as a report, and then adjusting to be able to print on one page.