I have a form that is actually a main form, a tabbed form, a subform on a tab, and a subform within that tab. The subform pulls from its own table and is populated by selecting one option from a provided dropdown box. I attached a macro to choose whether a new record needs to be added using the dropdown selection or whether an existing one needs to be updated.
Once the update has been made to the record, I'm trying to reflect the change on the form. I keep getting a conflict message. I've attached a copy of the subform and the error message. help.