Clearing Sub Form

[eagle670]

I renamed the table to SUB_CATEGORY and retyped the code. It still will not clear the form, getting the same error. Thanks for trying.

[June7]

You corrected the sql to have spaces?

Post the entire procedure code or provide db for analysis. Follow instructions at bottom of my post.

[eagle670]

Corrected the sql to have spaces, changed the names of the queries and tables to include underscores with no spaces. Database is way too large to post.

This shouldn't be this hard, I am sure that I am just over looking something. I have private message John to see if he would help me, I don't want to take up anymore of your time.

[June7]

Did you run Compact & Repair? Make copy and delete most records? Zip it?

Could upload to fileshare site such as Box.com and post link to the file.

[eagle670]

John_G has solved my issue. Thanks John for your help!