listbox doesn't populate

[ijared]

Private Sub Addtolist_Click()
Me.vol_my_worked_hrs.AddItem (Me.MyText1)
Me.MyText1 = Null
End Sub


I get no errors but the listbox doesn't populate. Any idea why?

[pbaldy]

What is the row source type? From help:

The RowSourceType property of the specified control must be set to "Value List".

[ijared]

Yes, the row source type is set to "Value List". My listbox is vol_my_worked_hrs and my comand button to add my textbox is

Private Sub Addtolist_Click()
Me.vol_my_worked_hrs.AddItem (Me.MyText1)
Me.MyText1 = Null
End Sub

[pbaldy]

Just tested and your code worked fine. How many columns does the combo have? I think you have to populate them all if more than one. If one, can you attach the db here?

[ijared]

Thanks. I think the problem must come from my database itself. I will look at it.

[ijared]

I don't seem to be able to solve. My column count is 2.

[pbaldy]

If there are two columns, I think you have to populate both. Can you attach a sample db here?

[pbaldy]

By the way, I never use value lists, always a table with the values. I share Allen's view:

http://allenbrowne.com/ser-27.html

[ijared]

I'got it working. I convert a combobox to a listbox and that must be a reason why nothing was going in. Now I have to figure out how to save this data evrtime data is put in..

[moke123]

cross post https://www.accessforums.net/showthread.php?t=71393