Adding new values from comboboxes to the visible list - technical solution

[jaryszek]

Hi,



i would like to do 1 combobox and when user will choose one value from it, this value should be add to the list below.
And i would like to add also possibility to delete choosen items from list by user.

After all choices user can click on the button and add new recors into summary table.
After this action list should be cleared and be ready for new data choosen by user.

What will be the best Access feature in order to do it?
Maybe somebody from you, Developers were building something like that?

Please help,
Best wishes,
Jacek Antek

[pbaldy]

I would probably just use a multi-select listbox. If you want to do what you describe, I'd have a local table to hold the selections. In the after update event of the combo, either use an append query or the AddNew method of a recordset to add a record to that table using the combo's value. Then requery the subform or whatever you have listing the values.

[jaryszek]

Thank you pbaldy.

Okey it seems ok. But...

I should have possibility to delete user selections after adding them to this local table.
And after reviewing them by user, there should be possibility to click on "Add button" and add all choosen selections into summary table.
After that selections should be deleted (to not hold a lot of not necessary data - i dont want to bloast the database).

I do not see exactly what you mean here.

Thank you for your help,
Best Wishes,
Jacek

[davegri]

jaryszek01.zip

Something like this?
tblColors is the source, tblTemp is a temporary table, and tblSummary is your end result.

[jaryszek]

Thankk you davegri !!!

It is very nice solution. I have to only change it a little (left listbox change to combobox).

Best wishes,
Jacek

[orange]

jacek,

Watch this video for additional info that may be useful.

May be useful in future...

[jaryszek]

Thank you orange !

Have a nice day my friend

Best wishes,
Jacek Antek