Limit To List

G

Guest

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
 

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

Similar Threads

Adding to a Table list using a Form 1
Limit Combo Box based on value of another 1
Passing a null value to a query 3
How to make a foreign column (instead of the foreign key) to be usedby built-in sorting 10
combo box not updated 2
How to update underlying file 2
combo box not displaying data if limit to list opetion set and displaying item not in list.... 4
Add query to Access control 1

Top