Displaying linked updatable and non updatable records in form

[supa_sumo]

My problem has now moved on to a form issue which means no one has been able to answer is in the queries section of the forum as there is no way around it using queries so i hope you can help. All information is available on this thread.
Thanks, Sci
http://www.access-programmers.co.uk/forums/showthread.php?t=100376

 

[aleb]

Just like Pat Hartman said : all you need is to create the additional subform which will have only calculated fields while your other subform will be updateable.

 

[supa_sumo]

Ok my fault didnt understand the explionation ive tried it now. im having problems refrencing the field of the linked subform. As everythikng is grouped by BikeID its confused me. I didnt thing i could use the footer to calculate the information because of the grouping.

 

[supa_sumo]

If I switch my form to form view to display the records referencing the subfomr field works fine but then when i put it to datasheet view i get #Error maybe as the subform does not get displayed. But basically it doesnt work.