Address selection on combo box help

C

Colin Weir

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
 
C

Colin Weir

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
 
J

John W. Vinson

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/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top