DLookup isn't working

[cec]

I have two forms...frm1 has a text box with an expression in it and I need frm2 to display the result of the expression. I'm using the DLookup expression and it either gives me #Name? or #Error? message in the text box frm2.



=Dlookup("[loan#]","tbl_loan","[Days] =" & Forms![frm1]!Days) <that gives me #Name? message

Can someone help me please I have tried everything...........i think!

Thanks!

[alansidman]

http://www.databasedev.co.uk/dlookup.html

Look here to ensure that your syntax for quotes is correct.

[ssanfu]

Does the table "tbl_loan" have fields "Days" and "loan#" (this is a bad name for a field - should only use letters, numbers and/or the underscore in names)
Is there a control on "frm1" named "Days"?
Is "Days" a number (like 3 or 6) or a date?

[cec]

"tbl_loan" does have fields "Days" and "loan#".

Yes there is a control on "frm1" named "Days"
Yes "Days" is a number.

[cec]

all the the information populates just fine on frm1(which i have expression built into the form)

its just frm2 I need the resulst to populate as they are in frm1. it will only populate the fields that do not have an expression in it.

[ssanfu]

"frm1" AND "frm2" are open at the same time?

[cec]

no. frm1 you can edit. frm2 you can not edit the "Days" text box.

[ssanfu]

=Dlookup("[loan#]","tbl_loan","[Days] =" & Forms![frm1]!Days)

Since this expression is in a control on "frm2", "frm1" MUST be open also since you are referring to the control named "Days" on the form "frm1".