Updating Table Records from a Subform linked to Main Form

[BenInOakland]

Hi, I am somewhat new to Access and database creation, so I hope this is a simple solution.



I have a Subform created with 5 fields, which is used to add a new record to Table = Meeting Minutes. 2 of the fields are bound objects referencing my main form, and one is a date field. The formulas are as follows:

1) =[Forms]![100-Select Form]![App]
2) =[Forms]![100-Select Form]![Project ID]
3) =Date()

Fields 4 and 5 reference the table:

4) Minutes
5) Notes

My problem is only Minutes and Notes (4 and 5) are updating my table (Meeting Minutes). I need App, Project ID, and Date to also update the record in the table. I've tried creating a button to Select All Records and Save, but this isn't working. My background is really only using Excel Formulas, which has helped an awful lot with Access, but this is all very new territory for me and a stretch of my skills.

Is there a simple way to accomplish what I'm trying to do?

Thanks!!!
Ben

[orange]

See if this link and video help.
https://599cd.com/tips/access/form-subform/

If not then please show use your Tables and relationships as a jpg

[BenInOakland]

That was a huge help!!! I didn't have any relationships setup, so this helped a lot. Thank you, Orange!!!

[orange]

You are welcome, glad to help.