Page 1 of 1

Inserting new fields into a form

Posted: Mon Mar 31, 2008 3:28 pm
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?

Re: Inserting new fields into a form

Posted: Mon Mar 31, 2008 3:52 pm
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.

Re: Inserting new fields into a form

Posted: Mon Mar 31, 2008 4:08 pm
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.