Re: subform (again)

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
>
>