 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / December 2007Bounding a combo box to a record
I am trying to create a combo box or a list that the users can select from. The list is the same for each record but I would like each selection to be independent of the other records. Example, I have 105 records and the user is supposed to go into their particular record and update the status as "On Track, Off Track...." When I tested out my combo box, I selected "on track" for my first record and all of the other records changes to "on track". Please help... I have checked all of my properties and I still cannot select from my combo box. I am working in MSAccess 2000. Please assist me... >I am trying to create a combo box or a list that the users can select from. >The list is the same for each record but I would like each selection to be [quoted text clipped - 6 lines] > >Please help... Is your form Contuous, Datasheet or Single View? >I have checked all of my properties and I still cannot select from my combo >box. I am working in MSAccess 2000. Please assist me... [quoted text clipped - 4 lines] >> >>Please help...  SignatureThere's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Sarchie, This would indicate that the combobox is unbound. That means that the Control Source property of the combobox is blank. You need to set the Control Source of the combobox to the name of a field in the table/query that the form is based on, in particular the field that the Status for each record will be recorded into. If there is currently no such field, you will first of all need to go to the design view of the table and add a field for this purpose. SignatureSteve Schapel, Microsoft Access MVP > I have checked all of my properties and I still cannot select from my combo > box. I am working in MSAccess 2000. Please assist me... [quoted text clipped - 9 lines] >> >> Please help... >I am trying to create a combo box or a list that the users can select from. >The list is the same for each record but I would like each selection to be [quoted text clipped - 6 lines] > >Please help... What's the Control Source property of the combo? What's the Recordsource for the form? It sounds like you have an unbound combo, or that you don't have a field in the table into which to store the status. John W. Vinson [MVP] |
Reply to this Message |
 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.