[Solved] Forms and Check Boxes

[Infamous Blob]

Hi folks
I'm new to OpenOffice and, although I have used most of the suites Microsoft counterparts (Word, Excel, Publisher e.c.t.) which do give you the knowledge you need to get started with OpenOffice, I've never used Access, which is a bit of a hurdle now I'm developing a database in Base.

With a few hours of testing and exploration of what everything does, I've managed to work out the basic elements of the application. There's one little thing I'm stuck on at the moment though - the check boxes function when generating forms. Although I've *just* worked out how to use the other elements, when I try to input a set of check-boxes, they all select/de-select at once when they're used in the form as if they were the same element.

It would be greatly appreciated if somebody would help me with this issue.

Thanks

[voobase]

It sounds like they are all using the same field from your data table for their data source.

A handy button to know about is the "form navigator" button on the "form design" toolbar. This enables you to see all the controls and forms in your form in a "tree" like view. It is then possible to select the control (checkbox) easily and right click it to look at its properties. You should check the data tab and see which field from your data table the checkbox is bound to. The reason the "form navigator" is handy is that often the controls are linked to their label when created with the forms wizard, so if you right click them on the form you don't get access to all there properties (you can ctrl click them though).

cheers

Voo

[Infamous Blob]

The issue appears to be exactly as you have described it, but I want them to all be attached to the one field with the aim of each checkbox adding to the data within.

For example, if I were to select "Bath" and "Shower", then the field would contain these two values (something like "Bath, Shower"). If I were to select only "Bath" it would only contain that value and if I were to select only "Shower" it would also only show that value. Is that possible, or will I have to set up multiple boolean fields to do this.

Thanks for your help so far by the way

[voobase]

For checkbox's you may need to have separate boolean fields. As Base is still a bit "Beta", checkbox's don't quite work as advertised. There is a property of the checkbox called reference value on and off. This property does not work.

The other alternative is to use "radio" buttons. For these the reference value on and off function does work. You could use a single integer field for them to put their data in and give each radio button a different reference "on" value. For your situation though you might be best using the checkbox's with their own separate fields in your data table.

Cheers

Voo

[Infamous Blob]

Thanks, I'll look into radio buttons, although I somehow think that using the boolean fields would be easier.

Thanks for the help again