Hello,
I am trying to build a database which has a checklist type functionality. I have created forms & subforms to present the information as I want it. My only problem is getting my macro to work correctly when inserting a new record into my primary table. The macro is Create a Record in the secondary table. The first SetField is supposed to pull a value from a field in the primary table. The other SetField statements are inserting static text data into fields in the secondary table.
I have followed the instructions by @JeffConrad in this thread on the microsoft forum:
https://answers.microsoft.com/en-us/...e-6cb36c93ffab
When I set it up the way he has, I still get an error for the SetField pulling info from the primary table:
The identifier '[Deal Profile].[Deal Name] could not be found. This is indeed the table and field name and I even used intellisence to ensure I pulled it correctly. I am not sure what I am doing wrong or how to fix it. I hope someone can help.