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