I have created a form that displays records from the Object table (filtered by Type=Table) in the header, and the Field table (filtered by the current Object.ID) in a subform.
The purpose of the form is to allow the user to mark any number of fields in the table (as excluded), and then generate a SQL script for that table to Sync the two tables in separate databases.
My issue is that I keep getting a “Field cannot be modified in this form.” error (referring to the Field subform). The thing is I never actually attempt to modify the records in that subform. Furthermore this error does not prevent the rest of my code from working properly. When I click OK on it, everything happens as I expected it.
If you need more informtion, let me know and I’ll be happy to supply it. Any thoughts would be great. Thanks in advance for your help.