Advanced Database – bound control properties

Apply, remove bound control properties like: limit to list, distinct values.

Limit to list and distinct values options are only available in MS Access, not Libreoffice Base.

19 List Box

Limit to list changes the properties of a combo box to only allow values from the list.

To do this in Base, you simply need to select the combo box, right click and select Replace with -> List Box

Then enter or link to values in the list box as shown in a previous lesson.