Thanks for the suggestion. Re-enabling warnings didn't offer much insight. Just the warning that the table rows would be deleted and then the 2 warnings that new lines would be added to the table.
SELECT * FROM productSearch shows the expected lines when viewing the query datasheet in Access...
Hello all,
I'm facing an issue that results in my SELECT query not returning all the results I am expecting. This could be due to an issue with my query or tables but I think it's most likely due to my usage of VBA in populating one of my tables hence why I am posting in the VBA section.
In a...