[Solved] ListBOX into a Subform table. CANNOT SEE values

Creating and using forms
Post Reply
flamen
Posts: 7
Joined: Wed Jan 06, 2016 8:29 pm

[Solved] ListBOX into a Subform table. CANNOT SEE values

Post by flamen »

Hi everyone.
In the first place, I.m a beginner. Excuse my ignorance.

I.ve included a subform that looks like a table, into a form. I want a couple of columns of that subform to display as a list box with dropdown menus. I replace the columns to listbox and in "DATA" of the column I select "TABLE" (in "type of list contents") and then I choose the table from "list content".
When I want to enter the data in the form I cannot the values when I click the arrow of the column. Why is that? I suspect that it is because the row of the table is very narrow and I cannot even see a bar for scrolling.

THANKS
Attachments
Screen Shot 2016-01-07 at 21.30.41.png
Screen Shot 2016-01-07 at 21.30.41.png (17.16 KiB) Viewed 1686 times
Last edited by RoryOF on Fri Jan 08, 2016 1:27 pm, edited 2 times in total.
Reason: Added [Solved] [RoryOF, Moderator]
OpenOffice 4.1.1. Mac OS.X. 10.9.5.
flamen
Posts: 7
Joined: Wed Jan 06, 2016 8:29 pm

Re: ListBOX into a Subform table. CANNOT SEE values

Post by flamen »

This how it looks if I extend the row and column
Attachments
Screen Shot 2016-01-07 at 21.34.20.png
OpenOffice 4.1.1. Mac OS.X. 10.9.5.
User avatar
charlie.it
Volunteer
Posts: 417
Joined: Wed Aug 21, 2013 2:12 pm
Location: Italy

Re: ListBOX into a Subform table. CANNOT SEE values

Post by charlie.it »

flamen wrote: and then I choose the table from "list content"…
Hi, choose instead Type of list contents: Sql and in List content write like my screenshot.
Attachments
Schermata 01-2457395 alle 21.48.21.png
charlie
Italian AOO Admin
macOS 14 Sonoma M1: Open Office 4.1.15 - LibreOffice 7.5.7.1

http://www.charlieopenoffice.altervista.org
flamen
Posts: 7
Joined: Wed Jan 06, 2016 8:29 pm

Re: ListBOX into a Subform table. CANNOT SEE values

Post by flamen »

It works perfect. THANK YOU VERY MUCH. I really appreciate it.
Best wishes
OpenOffice 4.1.1. Mac OS.X. 10.9.5.
Post Reply