G
Gilbert 2097
I've been using Access 2003 and combo boxes for a couple of years now and I
usually use a form to add a record when the not in list event fires and every
so often I experiment with new ways of implementing it. The question I've
had is what if the user misspells a name or location and they want to correct
it on the form that pops up. The trouble is that when the combo box is
requeried it uses the original data entered to look for a match and it
doesn't find one ( even tho the data from the popup is now in the table) so
the default message is displayed. I've tried setting the text portion of the
combo box to the new data entered by the user, but it hasn't worked so far (
maybe I'm doing something wrong or in the wrong place? ). I thought about
using the change event (which triggers when I do this) but can't come up with
a reasonable way to proceed. I know I could allow the user to change the
data later on a form tied to the table itself but i'd like to allow them to
change it 'on the fly', as soon as they realize they've made a mistake. I
hope I've explained this well enough that some one can help me?? I'm quite
familiar with the help on the not in list event in the msdn library so I need
some new articles that might deal with combo box inovations or related ideas.
Thanx for any help!!
usually use a form to add a record when the not in list event fires and every
so often I experiment with new ways of implementing it. The question I've
had is what if the user misspells a name or location and they want to correct
it on the form that pops up. The trouble is that when the combo box is
requeried it uses the original data entered to look for a match and it
doesn't find one ( even tho the data from the popup is now in the table) so
the default message is displayed. I've tried setting the text portion of the
combo box to the new data entered by the user, but it hasn't worked so far (
maybe I'm doing something wrong or in the wrong place? ). I thought about
using the change event (which triggers when I do this) but can't come up with
a reasonable way to proceed. I know I could allow the user to change the
data later on a form tied to the table itself but i'd like to allow them to
change it 'on the fly', as soon as they realize they've made a mistake. I
hope I've explained this well enough that some one can help me?? I'm quite
familiar with the help on the not in list event in the msdn library so I need
some new articles that might deal with combo box inovations or related ideas.
Thanx for any help!!