This is hopefully straight forward to resolve:
I have a report which contains a name including title at start. The title comes from a table called Title where the primary key is an autonumber in order to put the various titles in a sensible order rather than alphabetical when selecting from combo box on form (on the form where report pulls from the field is called Recipient Title). The problem is that although my formula works with name & surname as they are not combo boxes, the title pulls the primary key instead of the title.
=[Recipient Title] & " " & [Recipient Firstname] & " " & [Recipient Surname]
Hope someone can help.
I have a report which contains a name including title at start. The title comes from a table called Title where the primary key is an autonumber in order to put the various titles in a sensible order rather than alphabetical when selecting from combo box on form (on the form where report pulls from the field is called Recipient Title). The problem is that although my formula works with name & surname as they are not combo boxes, the title pulls the primary key instead of the title.
=[Recipient Title] & " " & [Recipient Firstname] & " " & [Recipient Surname]
Hope someone can help.
