Hi Fernand, still without having looked at Franco's sample DB ....
> I only can reproduce the Calculated field error, who is no error but a > mistake from Franco who uses a query as a datasource for a subForm. > Franco: change the datasource to the table where the Form-data must > been inserted and forgot the calculated field. There's not really a compelling reason why sub forms should not work with calculated fields or default values, neither technical nor conceptual. The approach has its limits, for instance, queries over multiple tables are not updatable, but this doesn't depend on their usage in sub forms. Ciao Frank -- - Frank Schönheit, Software Engineer [email protected] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
