I have a text box with the code
DLookUp("Month 1". "tbl_revenue", "[MID] = #" & Forms!frmreporting!subterm.form!txtMID & "#")
However for some reason it wont work.
i get an #ERROR displa...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Coding-Macros/Q_235...