Joe Hecht
jmhla at earthlink.net
Thu Jun 24 20:06:22 CDT 2004
I am trying to create a column for a combo box. tblMasterAddresses Fields LastName FirstName1 FirstName2 Pseudocode: If firstname2 ="",lastname,firstname1,lastname,firstname1 and firstname2 DispName: IIf ( [tblMasterAddresses]![FirstName2] = "", [tblMasterAddresses]![LastName] &" [tblMasterAddresses]![FirstName1] , [tblMasterAddresses]![LastName] &", "&[tblMasterAddresses]![FirstName1]& "and " & [tblMasterAddresses]! [FirstName2] ) I keep getting string error the last 30 minutes I have been working on it. Thanks JOE HECHT LOS ANGELES CA jmhla at earthlink.net