The diference betweein using combo from list box and table

[Frank Situmorang]

Hello,

Before I go further in desining my form, what is best way to update table
using combo box whether to use listbox or from table.

when I see the address sample of database the " Role" is taken from Role
table, Is not more simple if we make it as a listbox to update table?

Thanks in advance

 

[Arvin Meyer [MVP]]

List boxes are usually used to display or choose data in a form. Combo boxes
are used for searching, display, and for data entry on a form.

Always do the data entry from a form where you can construct rules and code
to verify the data. Never enter data directly into a table. If you feel you
can do more work with a datasheet, use a form datasheet, not a table.