I think you are basically beat because of the design. First, you form is based on 2 related tables and your record is a parent/child setup. Thus you cannot simply copy and append a record to this query because there will be no parent ID with which to relate the child record. Second, you cannot append all fields because some are calculated, thus they are read only. Lastly (for me anyway) several fields are lookup fields as already noted. These display what looks like normal data, but hide the fact that while you see "Joe Black" the value stored there is (e.g.) 22. IMHO you have made several critical design faux pas' and really ought to bite the bullet and fix them or you'll likely be posting here an awful lot. The issue is that those who are best qualified to help would likely never do these things so it makes it harder to know how to make them work for you. In the end, if you stick with what you have, you might make some progress if you convert the form to a form/subform design.
Maybe take a look at a few links?
Normalization Parts I, II, III, IV, and V
http://rogersaccessblog.blogspot.com/2017/03/what-is-normalization-part-i.html
and/or
http://holowczak.com/database-normalization/
Entity-Relationship Diagramming: Part I, II, III and IV
http://rogersaccessblog.blogspot.ca/2009/01/entity-relationship-diagramming-part-i.html
How do I Create an Application in Microsoft Access?
http://rogersaccessblog.blogspot.ca/2009/05/how-do-i-create-application-in.html
One source about how to name things -
http://access.mvps.org/access/general/gen0012.htm
What not to use in names -
http://allenbrowne.com/AppIssueBadWord.html
About Auto Numbers -
http://www.utteraccess.com/wiki/Autonumbers -
http://access.mvps.org/access/general/gen0025.htm
The evils of lookup fields -
http://access.mvps.org/access/lookupfields.htm
Table and PK design tips -
http://www.fmsinc.com/free/newtips/primarykey.asp
About calculated table fields -
http://allenbrowne.com/casu-14.html
About Multi Value Fields -
http://www.mendipdatasystems.co.uk/multivalued-fields/4594468763