Adding data via dropdown lists

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form with a dropdown list, which lists customers. The idea is that
they have to add the customer using a different form before they can select
that customer in the dropdown in this form. But sometimes they forget to add
the customer first, so when they go to select the customer in the dropdown,
he doesn't exist. This means they have to go all the way out of the form and
back into the "add customer" form. Is there any way they can add a new
customer via the dropdown?
 
If you want to require them to add data through your form, you can leave the
"Limit to List" property set to Yes and then use code the "On Not In List"
event of the combo box to open your existing form to a new record where they
can add the new customer and then when they have completed the data entry for
the new customer, the list box can be populated with the new entry they just
made.

Try searching these news groups for "Not in List" and see if you can get the
help you might need with this feature.
 
Thanks for providing the link, Tom. I did not have it handy when I responded
to the post.
 
Back
Top