microsoft access dlookup multiple values

There are no queries set up in the database for this report.

I was unable to upload my file.so a few notes of info. As a work around, I tried creating a calculation in the purchase order report, of =, and the pricing totals show fine on my report, but the subtotal doesn't work. However, the pricing information is not populating to my Inventory Transactions Table from the Purchase Order form by way of this Dlookup feature, and therefore will not show on my report, and in turn does not show in my Total of my Purchase Order report. I want the description and pricing to populate in the Purchase Order form, so I added Dlookup fields in the Purchase Order form.

Do I bring the actual field into the form and hide, and do some sort of after update, as I have tried and it does not work. =DLookUp('Salary','Salary Query') How I get the value from this unbound field to enter into the actual field in the table. However I have a few fields that I do a lookup in a field on the form from a query, and yes I know I should not have a lookup in the control source however, this is the way that I will be doing it on this occasion. If anyone can help I would be so greatful Thank you Nic I have a simple data entry form based on a table. I have tried to use the formula (=DateSerial(Year(StartDate),Month(StartDate),Day(StartDate)+21) in Defaul Value, without avail, and while the formula works in the Countrol Source, it wont save it to a table because it wont accept the formula and link together, so that I can do a report, or search on it. I have used DateSerial to calculate a future date in Microsoft Access form, but it wont save the calculated date on a table (I need the calculated date on a table so that I can generate a phone list sorted by dates). SupplierID and PersonID the supplierID works fine, i can add a new record and click save and it will save the data in the suppliers table.The problem is with my PersonID field, i need it to retrieve the data from my subform and firstly display in the field on my main form and secondly, when i click save it should save save the number that is displayed into my Suppliers table.

Microsoft access dlookup multiple values