Turn text box into dropdown box on form

[Kirjava]

I did it before but I can't remember how.
I have a form set up with text boxes, but I wanted to turn them into a dropdown list to minimise spelling mistakes.

I tried Replace with > List box, but it doesn't work. It just makes the box unresponsive.
Replace with > Combo Box puts a line along the bottom of the text box, and also makes it unresponsive.

Summary:
I already have a table.
I already have a form.
The purpose of the form is to add new items to the table
The form was made with the wizard.
The form has text boxes on it.
I want to turn some of those text boxes into dropdown boxes.
I want the dropdown box to display one of each input (eg. "Book", "Game", "Film & TV").


Edit: I added a list box and crtl + click to delete a text box, and put the list box where the text box was. It shows a huge list of 1090 items, instead of one of each. No idea how to make it work.

[Villeroy]

Ctrl+RIght-click>Replace with>Combo box
Data properties> Source type:SQL, Source:

Code: Select all

SELECT DISTINCT "column" FROM "table"

The combo box offers the already existing entries.You you can enter new categories any time because a combo box is just a text box with auto-complete.

[Kirjava]

It's better, but still not what I want.
I want a box with a list option so that I can add a new item type OR use one which I've already got in the table.

[RoryOF]

For information: OpenOffice comes with a built-in set of macros to handle Listboxes: these can be accessed through /Tools /Macros /Organise Macros /OpenOffice Basic /OpenOffice Macros /Tools /Listbox.

Understanding these and their use will require OpenOffice BASIC skills

[DiGro]

Villeroy is right. Check this:
https://www.youtube.com/watch?v=aOkkqaHRgzY