Hi all,

can someone help me to solvea this problem .
I have a table call customer with 3 fields ( fname – mname – lname ).

I also have a table called invoice and I would like to use a combo box to look up
In the customer tables and get all 3 of the above fields at once , is this possible.

I try to use customer[fname]&” “&[lname]&” “&[mname]
Not Working.

Thanks