Simple[?] listbox question

[BAzZ]

I have a form with 1 listbox, this is based on a table, with 1 field in it.
what do i need to do, to be able to add and remove items from this listbox!

Also with the removing part of it, removing many rows at once would be good aswell!

Any help would be muchly appreciated.

 

[WayneRyan]

BazZ,

You really shouldn't use List Boxes for data entry purposes. A form is much
easier, and is meant to display/update data from tables.

With a ListBox, deletion is possible, but it will take a lot of code.
Adding/modifying records will be next to impossible. I'd suggest
maintaining the data with a form.

Wayne

 

[BAzZ]

Thanks for the reply Wayne,

The purpose of it was to List staff members, in an easy to view list, and with the functionality of adding/deleting as needed.

the staff members aren't really a major part of the DB, they are only in a lookup table for a combo box, i was trying to design a user friendly admin form with the list box for the said purpose.

any ideas on how to do the add/delete for the lookup table, with a user friendly interface/control to display all items in the lookup table?

Thanks again for you reply

 

[godofhell]

Attached is a simple database with 1 Form listing all the members in datasheet view. Because it is a form you can always write your checks and balances on each field or simply set the properties you want on the form to lock it down as much as you need to. This is a much safer way for your users to add, delete, etc. Records since the form can be controlled by your checks and balances. The form runs from a query so it can be modified so that it only brings up certain records. Doing it this way will give your users the most functionality with the most control from your part.