The Form/Subform model you are trying to implement is an overly-complicated approach for the goal you are trying to achieve.
Recapping that you intended to reference the same single table as the recordsource for your main form and subform. I am guessing that you thought a form/subform model was the answer since part of your data included photo's and large memo fields as compared the the rest of the data you wanted to display in a spreadsheet style.
Form/Subform models are designed and traditionally used to handle one-to-many entity relationships i.e. the main form would typicall contain the parent record whereas the subform, would contain multiple child records all related to a key value in the parent record. A good example might be a Purchase Order. The parent record would contain fields such as the PO #, Vendor, Buyer etc. The child record would contain the PO #, PO Line #, Part Number, Quantity, Unit Price etc. In this example, the PO # would be used as the "Link Field" to synchronize the main form with the subform.
The main form would display one parent record at a time. The subform coud display more than one record associated with the current parent record and is typically setup as a continous form or datasheet form with a vertical scroll bar to scroll through the multiple child records while the main form fields remain visible on the screen i.e. the PO #, Vendor and Buyer would probably appear static at the top of the form while you scroll through the PO line items in the subform near the bottom of the form.
Having said all that about the form/subform approach, let's move on to what you really need here.
Since your single table contains all the fields you wish to display on the form, including the photos and fields you wish to display in a spreadsheet style, table relationships, much less a one-to-many relationship, don't even come into play.
Simply create one query which contains all the fields you want on your form.
Next, create a form using the Form Wizard with that query as its recordsource. NOTE: Most of the other prompts you'll receive in the Form Wizard are of little value here since you will ultimately have to do most of the design work manually while in Form Design View after the Wizard is done.
For simplicity sake, we'll position all the fields in the Form's Detail section.
In Form Design View, position the Photo and memo fields towards the upper region of the Detail Section.
Finally, position all the fields you want to appear in spreadsheet style i.e. each field might be formatted with a border outline and be aligned adjaecent to the next field. You would layout additional rows of fields beneath the first row if necessary. In doing so, you would create the appearance of spreadsheet rows and columns.
I hope this at least points you in the right direction.
