If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Drop down list
I have added a new column is the "Task" table and also set up a drop down
list, after i go and add this new column to the "Task" list form the drop down button is there but not my lst. i can go back to the table and the drop down list is there, what am i missing? |
#2
|
|||
|
|||
Drop down list
You have to requery your combobox rowsource:
DoCmd.Requery "YourCombo" -- --Roger Carlson MS Access MVP Access Database Samples: www.rogersaccesslibrary.com Want answers to your Access questions in your Email? Free subscription: http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L "Paul" wrote in message ... I have added a new column is the "Task" table and also set up a drop down list, after i go and add this new column to the "Task" list form the drop down button is there but not my lst. i can go back to the table and the drop down list is there, what am i missing? |
#3
|
|||
|
|||
Drop down list
I'm new to access so how would i do that? Thanks!
"Roger Carlson" wrote: You have to requery your combobox rowsource: DoCmd.Requery "YourCombo" -- --Roger Carlson MS Access MVP Access Database Samples: www.rogersaccesslibrary.com Want answers to your Access questions in your Email? Free subscription: http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L "Paul" wrote in message ... I have added a new column is the "Task" table and also set up a drop down list, after i go and add this new column to the "Task" list form the drop down button is there but not my lst. i can go back to the table and the drop down list is there, what am i missing? . |
#4
|
|||
|
|||
Drop down list
Actually, I think I mis-read your question originally.
If I understand correctly, you've added a new column to a table and, on your form, you have a combo box that uses that table as its Row Source. You see your new column in the drop-down list, but not in the combo box after making a selection. Is that correct? If so, look at your combo box properties. Modify the Column Count property and make that equal to the number of columns you expect to see displayed. Also change your Column Widths property to give values to each of the columns you want displayed. If this is not the problem, can you explain further? -- --Roger Carlson MS Access MVP Access Database Samples: www.rogersaccesslibrary.com Want answers to your Access questions in your Email? Free subscription: http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L "Paul" wrote in message ... I'm new to access so how would i do that? Thanks! "Roger Carlson" wrote: You have to requery your combobox rowsource: DoCmd.Requery "YourCombo" -- --Roger Carlson MS Access MVP Access Database Samples: www.rogersaccesslibrary.com Want answers to your Access questions in your Email? Free subscription: http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L "Paul" wrote in message ... I have added a new column is the "Task" table and also set up a drop down list, after i go and add this new column to the "Task" list form the drop down button is there but not my lst. i can go back to the table and the drop down list is there, what am i missing? . |
#5
|
|||
|
|||
Drop down list
I am using one of the pre made templates, i am adding two columns to a table
and in these columns i am adding drop down list where i have a list of words to choose from, i save it and then go to the Forms and i then add these new columns to the form and they do show up in the form after theve been added, my problem is that the list is not there ( The drop down button is), so im trying to get the list to show up that i added. "Roger Carlson" wrote: Actually, I think I mis-read your question originally. If I understand correctly, you've added a new column to a table and, on your form, you have a combo box that uses that table as its Row Source. You see your new column in the drop-down list, but not in the combo box after making a selection. Is that correct? If so, look at your combo box properties. Modify the Column Count property and make that equal to the number of columns you expect to see displayed. Also change your Column Widths property to give values to each of the columns you want displayed. If this is not the problem, can you explain further? -- --Roger Carlson MS Access MVP Access Database Samples: www.rogersaccesslibrary.com Want answers to your Access questions in your Email? Free subscription: http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L "Paul" wrote in message ... I'm new to access so how would i do that? Thanks! "Roger Carlson" wrote: You have to requery your combobox rowsource: DoCmd.Requery "YourCombo" -- --Roger Carlson MS Access MVP Access Database Samples: www.rogersaccesslibrary.com Want answers to your Access questions in your Email? Free subscription: http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L "Paul" wrote in message ... I have added a new column is the "Task" table and also set up a drop down list, after i go and add this new column to the "Task" list form the drop down button is there but not my lst. i can go back to the table and the drop down list is there, what am i missing? . . |
Thread Tools | |
Display Modes | |
|
|