OOo combobox equilivent to MS Accessc Combobox LimitToList

jitterbug · General User Joined: 25 Feb 2009 Posts: 10

Hi I'm looking for a way to add new records into a table using a combobox.
I have the combobox attached to a table "Receptions" with records in it and use this box to select items on my Contracts form
I also get a new records for the receptions table and would like to type it into the combobox to update my receptions table

MS Access has a combobox property limit to list which allows you to ccoose only
the records in the combobox - "Yes"
or add a new new record to the table using "No"

Thanks for any help you can supply

I'm using OOo 3.2 on Windows Vister

Villeroy · Posted: Mon Sep 27, 2010 7:10 am Post subject:

Like any other software, this has nothing to do with Access.

Use a list box to select a distinct reception into a foreign key.
You need another form (on the same form document) to enter a new reception. Then you can refresh the box (second refresh button on the toolbar) and pick the new reception. This is how I use to map thousands of items to thousands of other items without having too much trouble.
This way you can enter all new attributes of the new receiption and not just one.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org