Address selection on combo box help

December 06th, 2011 - 05:53 am ET by Colin Weir | Report spam
Hi there

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.

Hope someone can help.

Regards

Colin
email Follow the discussionReplies 2 repliesReplies Make a reply

Replies

#1 Colin Weir
December 06th, 2011 - 06:12 am ET | Report spam
Following this post I managed to do it. In the AfterUpdate of the Combo Box I put

If cbotown >= 9 Then
txttownother = cbotown.Text
End If

Seems to have done the job. I'll just assign town other to the reports for labels.

Thanks

C

Similar topics