Hi,
I have a Form [Quotes] and a Subform [QuoteDetails]. In my form I created a dropbox with an AfterUpdate event to append new records in the [QuoteDetails] table automatically. The problem is that since my code creates the records directly in the table without going through the form, there is no record created at the parent level, the [Quotes] table. Therefore my record in the child table [QuoteDetails] cannot be created.
The error is: Run-time error '3201':
You cannot add or change a record because a related record is required in table 'Quotes'
Any work around?