Listbox data cannot be saved in table

[cindyliu]

Hi Everyone,

I need your help!

I have a trouble to save data from Listbox to table. I can select mutiple data from Listbox, but the data cannot be saved on the table.

Here is the detail infor:

FORM name: Attendance
FORM record source: TBL_Attendance
Listbox Name: ARR_Result
table for Listbox to use: TBL_ARR

I want to these mutiple records which come from Listbox (data on the TBL_ARR table)to be saved in table TBL_Attendance.

Thank,
Cindy

 

[pbaldy]

Does this fit the circumstances?

http://www.baldyweb.com/MultiselectAppend.htm

 

[cindyliu]

Thanks, but it didn't help me much.:banghead:
Cindy

 

[pbaldy]

You know, some detail might help.

Here's another shot in the dark:

http://support.microsoft.com/kb/827423

 

[cindyliu]

Thanks, Pbaldy.

I tried the example which the link you provide to me. But that example does not save the listbox value in the table, it uses a TEXT BOX to display the listbox value.

please help me!

Cindy

 

[pbaldy]

Which link? If the second, I wouldn't go that way anyway, but the textbox would have to be bound to a field in the table (via its control source property).

 

[cindyliu]

Thank you so much, Pbaldy. When I bounded display field to the table, it works! I will put this into my real database, and let you know if it will work or not.

Thanks again

Cindy

 

[pbaldy]

Happy to help and welcome to the site by the way!

 

[cindyliu]

Thank you

Cindy