#error

[wildexodus]

What does #error mean when it comes up in a text box. Ive put some code into the control source of this text box to make it do a dlookup.

 

[FoFa]

Your Dlookup is not formatted correctly and returned an error

DLOOKUP("columnname","tablename","criteria")

 

[wildexodus]

=DLookUp("[UnitPrice]","[tbl1]","'[tbl1]![ Product]= '" & '[Forms]![frm1]![Forms]![text58].[Value]' & "'")

I think it must be my criteria thats gone wrong. Have i got the last bit right? Its meant to reference a textbox (text58) on frm1 (form).

 

[FoFa]

Try:
=DLookUp("[UnitPrice]","[tbl1]","[tbl1]![ Product]= " & [Forms]![frm1]![Forms]![text58].[Value])