Inserting new fields into a form

Creating and using forms
Post Reply
jdeflow
Posts: 1
Joined: Mon Mar 31, 2008 3:23 pm

Inserting new fields into a form

Post by jdeflow »

How can I insert a new field that I have added to a table into my already created Form that uses all the fields in that table? IN Access there is a drop down box with all the fields from the table you are using. How do I do this in OpenOffice base?
User avatar
r4zoli
Volunteer
Posts: 2882
Joined: Mon Nov 19, 2007 8:23 pm
Location: Budapest, Hungary

Re: Inserting new fields into a form

Post by r4zoli »

Open Form in edit mode right click on Form name. Activate Form Control toolbar View>Toolbars>Form Control. Click on control what you want to insert into form. Hold down left mouse button and draw rectangle.

Double click on newly created control. Properties pops up, select Data tab, select Data field, add your new filed from your modified table.
AOO 4.0 and LibO 4 on Win 8
Hungarian forum co-admin
User avatar
keme
Volunteer
Posts: 3780
Joined: Wed Nov 28, 2007 10:27 am
Location: Egersund, Norway

Re: Inserting new fields into a form

Post by keme »

First put the control you need (text box, checkbox, etc) on the form.
Then, if the object properties tool (Properties: <object type>) is not displayed, right click on your new control and select Control...
Select the Data tab in the properties tool.
Select the field for the control in the Data field dropdown list.
Apache OO 4.1.12 and LibreOffice 7.5, mostly on Ms Windows 10
Post Reply