query by form errorThanks for the response. No, it is not a typo. It is true to Irwin's code, seen below. I did try the variation, but the outcome is the same.
The single quote ' can replace the . It's usual purpose is to avoid confusion of property names and object names. I don't think there's a problem here, but since Irwin used it, it seems practical. (If, for instance, you have a field named Color.)
The issue has been resolved. It was apparently caused by a typo in the name field on the form (which I suspected, but I guess I can't even proofread four letters at a time.)
Below is the orignial code for the Orders database on the form. In my adaptation the db field name is NAME, the field in the search form is fldNAME. I am sure I will find more issues as I continue with the project.
I know that Paradox has not been very important to Corel for some years now, but it's a pity that they don't offer this feature via interface. It would make the program enormo... |