Controlling a subform based on a query with a main form

[Pete-RM]

I am trying to create a database that displays the cost of all of my meals and allows me to apply certain meals to certain Days.

At the moment I have created a form (called frmMainMeal) based on a query that allows me to create meals by selecting different products. This works fine.

Now that I have created some meals I would like to use a form to apply the meals to certain days. (keep in mind that I would like to be able to use the same meal on more than one day).



I have created a form (called frmMainDay) with a subform based on a new query that I created (the query totals the $ amounts of each meal), however I cannot enter data into the subform.

I am new to access and don't know how to fix this issue.

I have attached the access file for your reference.

meal template - Copy.zip

[ranman256]

If you have a main form w a keyID (autonum) for the record,
then the sub form will need:
keyID (long integer) duplicates OK
SubID (autonum)

set relationships on these 2 tables to allow mulitple record entry
also in the form/subform design, set the subform LINK MASTER FIELDS, and LINK CHILD FIELDS to keyID

JUST the sub table... your demo has too many tables involved.