No Such Field in Field List - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images Link Email

No Such Field in Field List

Amanda McDonald

14 months ago

One of my controls is getting the "No Such Field in Field List" error however, the data is populating fine on the form.

The record source is a query.
The field is in the query.
The field is in the table used to make the query.
The field is an option in the control source drop-down menu for the control.

I have tried:

- Checking spelling, it is spelled correctly.
- Deleting the query from the record source of the form, saving it, re-opening the form, and adding the query back as the record source, but the control still has the error.
- Deleting the field from the query, saving the query, re-opening the query, and adding the field back to the query but the control still has the error.
- Deleting the control and adding a new control, but once I select the field as the control source I get the error again.
- I created a new form with the wizard and it added all the fields except the field with the error. When I added a control and selected the field for the control source I got the error.
- I created a completely new query and a completely new form and I got the error.
- Debug> Compile found no errors.
- Ran Compact & Repair on the front-end and back-end of the database. The error is still there.

Even though there is an error, right now the field is populating the correct data on the form.
I'm tempted to just ignore it...however, I don't want to have issues with the data in the future

I have Googled and tried ChatGPT and all I can find is that "the field doesn't exist"...but it does exist...and it is populating data...I don't know where to go from here. Any help would be very much appreciated.

	Amanda McDonald OP 14 months ago

	Amanda McDonald OP 14 months ago

	John Davy 14 months ago
Hi Amanda If it is not confidential and you want to send the app to me, I will take a look at it. John [email protected]

	Sami Shamma 14 months ago
Amanda Your troubleshooting skills are very good. Try the following, just in case there's a problem with the way this field was initially created: Create a new field on the same table call it TileCleaning2 Then add that to the form and the query. If this works, simply write an update, query to move the data from the original field to the new field.

Amanda McDonald OP

13 months ago

I had some time this afternoon so I went into the query SQL and found the problem. There was a space at the end of the field on the table. (Palm to forehead.) I removed the space on the table and replaced the field in the query and the error is gone! I am a bit embarrassed that I didn't catch this before I posted it. Perhaps this will help someone else in the future. I would never have solved this on my own without looking at the SQL. Lesson learned, check the SQL first!
I appreciate you all taking a look at this.

	Amanda McDonald OP 13 months ago

	John Davy 13 months ago
Hi Amanda As Sami said "Your troubleshooting skills are very good" Congratulations! John

Amanda McDonald OP

13 months ago

Thanks, Sami & John, I try. I came from working with basic Excel spreadsheets to Access and have only used it for a couple of years. There was a big learning curve starting with VBA and now onto SQL but I finally feel like I've got a handle on it. I feel like I've only scratched the surface of what it can do. I would not have been able to create our company's database without Richard's videos, templates, seminars, and help from you guys here at the forums. Thank you!

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.