Guys, I'm getting an error I cannot resolve, so any help is greatly appreciated.
DESIGN - "Repack Dashboard" Table takes in information from Production Order table and Sales Line table. It is generated when a user opens the Repack Dashboard form. The Repack Dashboard form contains a table box with Repack Dashboard info and two subforms with info from Production Order and Task Center information.
ISSUE - When filters are applied such that all data is filtered out (because nothing meets the filter criteria), the table box is empty. If the user clicks on the table box with no entries, an error pops up saying "Repack Dashboard already exists". The error is reproducible and consistent. It happens when the table box is empty. Then clicking on any of the subforms or the table box will pop up this error.
INVESTIGATION - I've run the debugger to understand when this error pops up, but the debugger doesn't catch this error at all. It runs through my code and the error pops up when the debugger is done.
If anyone has come across this issue, please point me in the right direction. Not sure if it is my design or a bug, or a property I have to set.