Hi
I am trying to right an invoicing application and using Dlookup on a report to have it automatically bring in the billing addresses. I have trawled the web to find the correct code but it keeps giving me an error :banghead:
So you can see what I am trying to achieve here is an example of code I have tried.
As a control source in a text box
Dlookup("[Unit_Address]","[tbl_Units]","[Unit_Code]=" [cbo_unit])
cbo_unit is a combo box on the report.
I have read somewhere there is a difference between txt and number code?
I know its probably something simple but I am new to this kind of coding.
Please help. Getting very frustrating.
Many Thanks.
I am trying to right an invoicing application and using Dlookup on a report to have it automatically bring in the billing addresses. I have trawled the web to find the correct code but it keeps giving me an error :banghead:
So you can see what I am trying to achieve here is an example of code I have tried.
As a control source in a text box
Dlookup("[Unit_Address]","[tbl_Units]","[Unit_Code]=" [cbo_unit])
cbo_unit is a combo box on the report.
I have read somewhere there is a difference between txt and number code?
I know its probably something simple but I am new to this kind of coding.
Please help. Getting very frustrating.
Many Thanks.