Hi Guys, I've created a library database and when I add a new publisher name to tblPublisher and refresh my primary data entry form, the following error appears (see screenshot),
'You cannot add or change a record because a related record is required in tblCentury'.
Following this when I hit my Refresh macro button (on the main form), I get the additional dialogue box: 'Stop All Macros'.
When I then close-reopen the database, I'm then able to then see the added Publisher from the drop-down combo box list. Just wondering if anyone might have a suggestion how to fix this bug. Am happy to provide further screenshots to assist. Thanks.