| View previous topic :: View next topic |
| Author |
Message |
cyningstan General User

Joined: 02 Nov 2009 Posts: 9 Location: Kingston upon Hull, England
|
Posted: Mon Nov 02, 2009 10:21 pm Post subject: Adding multiple fields efficiently in a sub form |
|
|
This is more a question of convenience than necessity.
I'm designing a form with a subform. The subform uses fields from a secondary table. Each time I add a new field in the form design module it sits directly under the main form in the form structure shown by Form Navigator. I have to use the Form Navigator to move the new field to the subform before I can specify what field it represents under the Data tab of the control's properties dialog. If I don't, I'm not given the choice of specifying a field from the secondary table. This makes adding a series of fields to a subform quite tedious and I suspect I'm missing something. I can't find anything in the built-in help about this.
Is there a way in the form designer to signify that anything you add from this point on should be part of the subform? Obviously I'd want to go back to adding things to the main form once I've finished designing the subform.
Thanks! _________________ Damian |
|
| Back to top |
|
 |
Bayer General User

Joined: 04 Dec 2008 Posts: 21
|
Posted: Tue Nov 03, 2009 4:29 am Post subject: |
|
|
first select your subform by navigator
then you can create controls to the active subform
regards from Germany
Eckhardt |
|
| Back to top |
|
 |
cyningstan General User

Joined: 02 Nov 2009 Posts: 9 Location: Kingston upon Hull, England
|
Posted: Tue Nov 03, 2009 7:33 am Post subject: |
|
|
Thanks Eckhardt.
Unfortunately in OO 3.1 Base that didn't seem to work reliably for me. The first control I created would appear in the subform, but any after that appeared in the main form--even when I specifically selected the subform in the navigator before trying to add each control.
I'll double check everything I do when I design my next form and subform to see if it's one of those things that OO does one day and not the next. I've been finding quite a few of those over the past couple of days! _________________ Damian |
|
| Back to top |
|
 |
cyningstan General User

Joined: 02 Nov 2009 Posts: 9 Location: Kingston upon Hull, England
|
Posted: Tue Nov 03, 2009 8:02 am Post subject: |
|
|
I happened to think of an edit to my form which involved adding some new fields, so I got to test this earlier than anticipated. I can confirm that selecting a subform in the navigator before adding a control does not cause that control to appear in the relevant subform. I still need to move the new control into the subform after adding it. _________________ Damian |
|
| Back to top |
|
 |
RPG Super User

Joined: 24 Apr 2008 Posts: 2696 Location: Apeldoorn, Netherland
|
Posted: Tue Nov 03, 2009 8:04 am Post subject: |
|
|
Hello
What you describes is right. When it is a great problem go to a version what is more stable. I'm not sure but I think that OOo2.4.3 does work better for the problems you see. But it does not have other things OOo3.1.1 have. It is your choice.
Romke |
|
| Back to top |
|
 |
cyningstan General User

Joined: 02 Nov 2009 Posts: 9 Location: Kingston upon Hull, England
|
Posted: Tue Nov 03, 2009 10:10 am Post subject: |
|
|
Thank you Romke for your response. This particular problem was a minor inconvenience but didn't stop me completing the form. Unfortunately due to other problems mentioned elsewhere (the unique key auto increment bug) I've decided to abandon the project and remove OO Base from my computer. As I still use the other programs in the OO suite I'll keep an eye on future releases of OO Base but I think this project will end up being done in Access. Thanks again for your help. _________________ Damian |
|
| Back to top |
|
 |
|