I am getting the following error when trying to load a form, with a subform and filter it.
It worked previously, but since migrating to firebird there is an issue.
It is trying to filter the form that is being loaded on a field where JC1364 is the first record that is not a number, but I can’t work out why it is trying to convert it to anything but a string.
*conversion error from string “JC1364”
I have attached the database as I don’t feel I have explained it well. The error occurs when on the Job_Listing form and pressing the View Job button.
Any help would be greatly appreciated
ProductionDatabase.odb (148.9 KB)