The database I am working on covers a local area. For ease of data collection I have created a combo box that has a list of the main townships in it. There is also the option for "other". When this is selected a text box appears for the user to enter in the "other" town name. My problem is going to be when labels are being printed as I don't want the term "other" to appear on this. Is there any way around this?
I wondered about getting the value from the combo box to always be passed to the Town Other text box unless "Other" is selected and use this for addresses, but unsure if this is possible.