DLookup as ControlSource for a text box?

[GraeagleBill]

I have a table where I want to store recordID's and have the ID's used to find values in another table when the ID's are greater than zero and use those values to populate a text-box. I think I essentially want an un-bound text-box with a value lookup when the ID is non-zero. If that's the correct thinking, what would an expression look like for the unbound textbox? Something like: If ID>0 then dlookup value1 in mytable where recID = ID ????



I tried to accomplish the task within a query, but couldn't find success there. Also with the DB relationship but doesn't handle the zero ID properly.

Thanks,
Bill

[June7]

Why would ID be 0? What field do you want to return value from?

=IIf(ID>0, DLookup("field","table","ID=" & [ID]),Null)

[GraeagleBill]

ID's are being assigned. If an assignment has been made, then the textbox would be populated with text values taken from the table from which the ID's are found. If an ID is zero, then the textbox should be a zero-length string.

I'll try your expression and post back.
Bill

[June7]

For zero-length string:
=IIf(ID>0, DLookup("field","table","ID=" & [ID]),"")

[GraeagleBill]

Thanks, issue solved.
Bill