I have two calculated fields in a query, one shows the age in years, the other the remaining months e.g. 7 years & 8 months. The calculation works perfectly in the query and also when I build a form based on the query, however If I then make that form a sub-form inside another form it errors. I have made no changes to the form or query at all. Could anyone suggest why this might be and how to fix it? Thanks
Opened as a sub-form within another form
Same form but open independently