The diference betweein using combo from list box and table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Frank Situmorang - 28 Dec 2007 02:22 GMT

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

Signature

H. Frank Situmorang

Reply to this Message

Arvin Meyer [MVP] - 28 Dec 2007 03:31 GMT

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.

Signature

Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

> Hello,
>
[quoted text clipped - 5 lines]
>
> Thanks in advance

Reply to this Message