Adding data via dropdown lists

[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?

 

[Guest]

Change the Limit To List property from Yes to No.

 

[Guest]

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.

 

[Guest]

To add to Mr. B's input, I'll shorten your search by giving you this link,
which you should bookmark: http://allenbrowne.com/tips.html

Look for "NotInList" in the Combo Boxes section.


Tom
<MS Access MVP>

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Guest]

Thanks for providing the link, Tom. I did not have it handy when I responded
to the post.