M
Melissa Boggan
Help! I am under a deadline to solve this issue and haven't been able to get a response in other message boards or groups
I am trying to force the "File As" field to display the standard "Last, First" or "Company" values, along with an ID number that is in a User Field. For example, the "File As" value for John & Mary Smith could be "Smith, John & Mary - 123456" (where 123456 represents a unique ID number that I have preassigned to that name)
I have tried the following formula in the "Set Initial Values" section of the Properties for "File As". It isn't producing the desired result
IIf([Full Name] <> "", IIf([Company] <> "", [Last Name] & ", " & [First Name] &" and "&[Spouse] &"; "&[User Field 3]& Chr(13) & Chr(10) & [Company], [Last Name] & ", " & [First Name] &" and "&[Spouse]), [Company]&"; "&[User Field 3]
The "File As" field is just defaulting to a semi-colon, so I am assuming that my formula is incorrect. However, when I then complete the necessary fields on the form such as Full Name and Company, the "File As" field doesn't update as if it is dependent on these fields
Help
Thanks
Melissa Bogga
I am trying to force the "File As" field to display the standard "Last, First" or "Company" values, along with an ID number that is in a User Field. For example, the "File As" value for John & Mary Smith could be "Smith, John & Mary - 123456" (where 123456 represents a unique ID number that I have preassigned to that name)
I have tried the following formula in the "Set Initial Values" section of the Properties for "File As". It isn't producing the desired result
IIf([Full Name] <> "", IIf([Company] <> "", [Last Name] & ", " & [First Name] &" and "&[Spouse] &"; "&[User Field 3]& Chr(13) & Chr(10) & [Company], [Last Name] & ", " & [First Name] &" and "&[Spouse]), [Company]&"; "&[User Field 3]
The "File As" field is just defaulting to a semi-colon, so I am assuming that my formula is incorrect. However, when I then complete the necessary fields on the form such as Full Name and Company, the "File As" field doesn't update as if it is dependent on these fields
Help
Thanks
Melissa Bogga