To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=91541 Issue #|91541 Summary|OOo Base. Wizard to create form. Add subform. Click ba |ck. Values of tables and fields not stored. Result bad | form. Component|Database access Version|DEV300m22 Platform|PC URL| OS/Version|Windows 2000 Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|lcn
------- Additional comments from [EMAIL PROTECTED] Thu Jul 10 10:47:03 +0000 2008 ------- Tested with OOo-Dev_DEV300_m23_Win32Intel_install_en-US.exe on Windows 2000 French. Also found in openoffice 2.4.1 French. In OOo Base, with "Wizard to Create Form…" and add subform, when clicking back, values of tables and fields are not stored. And it results a bad form. I'll attach an odb file, use it for the test. The odb file contains : - a form with the bad subform resulted with the previous description - and a form good subform if only click on "Next >" button. Way to reproduce. 0.- Download the attached file and open with OOo Base 1.- In "Database" panel (left panel), click on "Forms". 2.- In "Tasks" panel (center panel), click on "Use Wizard to Create Form…". The "Form Wizard" appears. 3.- In step 1 (Field selection). Select "Table: Employees". Click ">>" to move all values from "Available fields" to "Fields in the form". Click "Next >". 4.- In step 2 (Set up a subform). Check "Add Subform". "Subform based on manual selection of fields" is selected by default, if not, select it. Click "Next >". 5.- In step 3 (Add subform fields). /*** In "Available fields", values of table comments appear, it shouldn't be if no table is chosen ***/. Select "Table: Comments". Click ">>" to move all values from "Available fields" to "Fields in the form". Click "Next >". 6.- In step 4 (Get joined fields). In "First joined subform field", select "EmployeeNumber". In "First joined main form field", select "EmployeeNumber". Click "Next >". 7.- In step 5 (Arrange controls). Click "< Back". 8.- In step 4 (Get joined fields). /*** The previous values disappeared ***/. Click "< Back". 9.- In step 3 (Add subform fields). /*** The previous value disappeared ***/. Click "Next >". 10.- In step 4 (Get joined fields). Click "Next >". 11.- In step 5 (Arrange controls). In "Arrangement of the main form", select the second arrangement (Columnar - Labels on top). In "Arrangement of the subform", the third arrangement (As Data Sheet) is selected by default, if not, select it. Click "Next >". 12.- In step 6 (Set data entry). "The form is to display all data" is selected by default, if not, select it. Click "Next >". 13.- In step 7 (Apply styles). Click "Next >". 14.- In step 8 (Set name). Click "Finish". 15.- /*** The Subform doesn't work as it should be ***/ Solution. >From 9.- of the way to reproduce. - In step 3 (Add subform fields).Select "Table: Comments". Click "Next >". - In step 4 (Get joined fields). Click "Next >". /*** You don't need to select the fields. Bug ? Default value ? ***/. - To continue, start from 11.- of the way to reproduce. /*** At the end, the subform works ***/ --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]