Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms Programming / November 2005

Tip: Looking for answers? Try searching our database.

Limit To List

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
SharonInGa - 30 Nov 2005 17:01 GMT
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.
Marshall Barton - 30 Nov 2005 18:01 GMT
>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.

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

    Me.thecombobox.Requery

Signature

Marsh
MVP [MS Access]

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.