Xenix Registered User. Local time Today, 02:13 Joined Oct 8, 2001 Messages 124 Jan 28, 2002 #1 Can anyone show me how to put table names within a text string on my form? I want: "[Company] is a [Relationship] to [Company2], What is [Company2] to [Company]?" Thank you for any advice Mike
Can anyone show me how to put table names within a text string on my form? I want: "[Company] is a [Relationship] to [Company2], What is [Company2] to [Company]?" Thank you for any advice Mike
Xenix Registered User. Local time Today, 02:13 Joined Oct 8, 2001 Messages 124 Jan 28, 2002 #2 Ok sorry guys, found it: =[Forms]![FormName]![FieldName] & " is a " & etc. for anyone else that wants to do it Mike
Ok sorry guys, found it: =[Forms]![FormName]![FieldName] & " is a " & etc. for anyone else that wants to do it Mike