Add IF statement to report field.

[bradp1979]

Attached is a picture of my Special Event Report Sheet, (SERS). The field "Client" takes its data from tblClient, EntityName. I want to tell it "If entity name is null, then use ContractingPartyContactID from tblEvent."



Where/how do I do that?

Also, when I told it to use only ContractingPartyContactID, it used the ID number instead of the name of the contact. How can I change that?

Thank you.

[ranman256]

have an unbound text box txtName, to show the result
in the ONCURRENT event of the form
put the if to show the needed item

sub form_OnCurrent()
if isnull(EntityName) then
  txtName = ContractingPartyContactID
else
  txtName = EntityName
end sub

[bradp1979]

ONCURRENT is not an option on the property sheet under the Event tab.

[pbaldy]

Presuming both fields are in the source query, you can use the Nz() function.

To your second question, in the source query you would join the two tables on the ID field, enabling you to return the text field.