Limit To List

S

SharonInGa

My form has a combo box that allows the user to select a customer using auto
type. The combo box is based on a table that has a auto Customer RecordID#
and the CustomerName. How can I user both the "Auto Type" feature and the
"Limit to List = No" features. I've tried added a command button that
allows the user to add a new customer to the customer table, however, the new
record is not showing up in the original form with the customer combo box.
 
M

Marshall Barton

SharonInGa said:
My form has a combo box that allows the user to select a customer using auto
type. The combo box is based on a table that has a auto Customer RecordID#
and the CustomerName. How can I user both the "Auto Type" feature and the
"Limit to List = No" features. I've tried added a command button that
allows the user to add a new customer to the customer table, however, the new
record is not showing up in the original form with the customer combo box.
Click to expand...


The button's code needs to requery the combo box after the
new record is added.

Me.thecombobox.Requery
 
Top