Is it possible to do this? If I have a report that lists C4501, can I populate another textbox with City? Or S4560 would populate the field with Suburb.
Is it possible to do this? If I have a report that lists C4501, can I populate another textbox with City? Or S4560 would populate the field with Suburb.
You would do it with an If statement in the AfterUpdate event of the field. Not sure what you meant by "report".
In the Control Source of the Text field(replace Field1 with your report field name):
= IIf Left([Field1],1) = "C", "City", IIf Left([Field1],1) = "S", "Suburb","NA")
Thanks. This worked well.