Frank ,Franco
Indead "one table" query's works
Calculated fields works also if the "column" properties of the form
control are set to "Input NOT required" and "prevent data entry"
Greetz
Fernand
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
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
