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 / New Users / September 2005

Tip: Looking for answers? Try searching our database.

combo box value repeats in database view

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
shoiley - 01 Sep 2005 02:45 GMT
I have created a combo box in a form. When I select a value for the first
form -  that value appears for all the forms in database view.  Why is that?
Is it possible to convert an existing field box to a combo or list box?
Signature

Thank you kindly

Wayne Morgan - 01 Sep 2005 02:54 GMT
Is the form in continuous or spreadsheet view and the combo box unbound? If
so, it will do that because there is really only one combo box. Without a
bound record to change what it displays, when you make a selection the same
selection will appear in each record. The same thing will occur in single
form view, it's just that you don't see it until you go to the next record
and notice that the combo box still has the last selected value in it.

Signature

Wayne Morgan
MS Access MVP

>I have created a combo box in a form. When I select a value for the first
> form -  that value appears for all the forms in database view.  Why is
> that?
> Is it possible to convert an existing field box to a combo or list box?
Marc - 01 Sep 2005 02:56 GMT
<snip>
"shoiley"
>I have created a combo box in a form. When I select a value for the first
> form -  that value appears for all the forms in database view.  Why is
> that?
> Is it possible to convert an existing field box to a combo or list box?
Do you mean the first record? Then yes, that is the way it works. Rather use
continuous forms.
HTH
Marc
 
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.