field not updating in Database via ListBox

[Shift838]

I have a list box that I add Members to with an add button and it pops up an Input box. The listbox gets updated with what I input in the inputbox but the database does not get updated with what is in the list box. I have my field setup in the database as Text. My code is below:

Dim stradd As String

stradd = InputBox("Enter Member")

lstgroupmembers.AddItem stradd

 

[MajP]

what is the controlsource of the listbox?

 

[Shift838]

I have the controlsource set to my text field within the database it is called txtGroupMembers.

 

[PHV]

How do you expect a text field be storing a list box control ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Shift838]

I have even changed the text field to Value List and ListBox for the properties but it does not store the information in the database when the listbox gets populated.

 

[Shift838]

This is what I need to do and maybe someone can tell me how to do it.

I need to be able to allow users of the database to update a list box with multiple entries and when updated the listbox will write to the database. And of course the list box will read the database with the correct values.

I would like to be able to update the listbox with multiple entries at the same time and the each different entry (like names) be added on a different row.

 

[PHV]

Why not simply use a continuous bound form ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Shift838]

I do not know what a continuous bound form is.

 

[TheAceMan1]

How are ya Chris77504 . . .

[ol][li]Open any form in design view.[/li]
[li]Call up the form properties window.[/li]
[li]Select the [blue]Format[/blue] tab in the properties window.[/li]
[li]Put the cursor on the [blue]Default View[/blue] property line ... hit [blue]F1[/blue] and read about form views.[/li][/ol]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]