Previous Issue Solved however caused more errors elsewhere...

[Stephanie53]

Here is the previous issue: https://www.accessforums.net/forms/n...ted-34330.html

Now when I select to see the Purchase Order Details form I get this error:



Please know that I changed from Unit Cost in the previous issue to have it read and post under List Price and changed the code accordingly after I saw this error and I still get this error.



TIA for all your help in this matter

Stephanie

[Missinglinq]

The error would seem to indicate that there is a SQL statement, somewhere, that you haven't edited to reflect he Field name change. Understand that some SQL statements are generated by the Access Gnomes via various Wizards, and you may not even be aware that they exist. One example of this would be the creation of a Table-based Combobox, using the Wizard. You place the Control on the Form, the Wizard pops up, and you pick a Table or Query as a source, then you select Fields to include in the Combobox. If you then select the Combobox and go to Properties - Data and look at the RowSource Property, you'll see that Access has used a SQL statement to create a SELECT Query.

Depending on the size of your app, it could take a bit of time tracking all such occurrences down.

Or, of course, it could be an Access 'ghost!' These creatures do occasionally remain after changes like this have been made. They cure for this, I believe, is to import everything into a new, blank database.

Linq ;0)>

[Stephanie53]

Found the issue :-) Thanks :-)

[Missinglinq]

Glad you got it fixed!

Linq ;0)>