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 goingto 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

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

On Tue, 6 Dec 2011 03:12:21 -0800 (PST), Colin Weir
<(E-Mail Removed)> wrote:

>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

You could consider using the combo box's Not In List event to offer the user
the option of actually adding the new, typed-in township to the table; if you
have one address from that township you might have another someday.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/For...-US/accessdev/
http://social.answers.microsoft.com/.../en-US/addbuz/
and see also http://www.utteraccess.com