Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

In a listbox, the value displayed is the first one in the selection. The value stored is the one indicated by the Bound field. this bound field is relative to 0, so in your examples the concatenated field (Name) will be displayed and if the AuthorID is what is to be saved, then Bound field should be set to 1.

If you are looking to display one value & save another you need to use a list box. In a listbox, the value displayed is the first one in the selection. The value stored is the one indicated by the Bound field. this bound field is relative to 0, so in your examples the concatenated field (Name) will be displayed and if the AuthorID is what is to be saved, then Bound field should be set to 1.

With a combo box, the displayed value is the value saved. The advantage of the combo box is selecting from the list or entering a value not in the list.