Dlookup Problem

[sdel_nevo]

Hi All



i am struggling to get my head around Dlookups and Dsum so im really sorry to be asking another question on this subject.

i have a form called "List of customer orders" that ineed to show the "amount left to pay" from the Edit orders form in a text field called "Outstanding Amount"

"Amount left to pay" is an unbound text field

the problem is i can't work out the syntax for the Dlookup

this is what i have been using with no luck!!

me.Outstanding_Amount =DLookUp("[OrderID]","[Orders]","CustomerID=" & "[Forms].[Edt Orders].[Amount_Left_To_Pay_TXT_Box]")

i have also tried to use this

Forms![Edit Orders]![Amount_Left_To_Pay_TXT_Box] on it's own but no luck.

the edit orders form is not open as i want the "List of Customer Orders" form to show me how much has been paid from each customer order, without me having to open each one up individually.

once again im sorry if this is very similar to previous questions.

many thanks

Steve

[pbaldy]

This should help:

DLookup Usage Samples

[sdel_nevo]

Hi Paul

Many Thanks for the link.

i may have been abit silly here

im not sure that i can use a dlookup because the value im looking for is not held in a table, its calculated in the fly on the edit orders form, i need to see the value of the "amount left to pay" field " that is unbound and show that on the "List of customer orders form".

is this something that dlookup can do?

i find all this really confusing lol

Steve

[pbaldy]

No, it can't. You should be able to refer to the form control from elsewhere in the db, as long as it's open.

[sdel_nevo]

Hi

What Happens if the form is not open, is there a way to get he value?

Steve

[pbaldy]

No; you'd have to recreate the calculation.

[sdel_nevo]

Hi Paul

Many Thanks

Steve

[pbaldy]

No problem Steve.