How to remove field from Field List?

[liutofsik]

I had two fields in my table which I previously used in the form. I deleted the fields from the form itself but the fields are still listed under Field List and not even under any table...

Delete buttons doesn't work on it, and neither does backspace?
How do I remove it? Right click only gives me two options:

"Add Field to View" or "Edit Record Source" which returns an error saying this command cannot be used.

 

[essaytee]

Go to your table and delete the field from there.

 

[liutofsik]

This problem is happening because I deleted the field from my table.

 

[AlexM]

I just had the same problem.
Go to the form properties and delete the columns from the SQL code in Records Source

 

[Pat Hartman]

Welcome aboard The post you replied to is 9 years old but looks like it never got answered correctly so thanks.

 

[AlexM]

I didn't even notice that.
I was just looking for a solution for the same problem LOL

 

[Pat Hartman]

Helpful people are great to have around.

 

[jonnyboy5]

I didn't even notice that.
I was just looking for a solution for the same problem LOL

Well it helped me just now. I had a combo box value list int he query that was causing multiple entries to appear in a form, and this just solved it. Thanks!

 

[Pat Hartman]

See @AlexM. you've already made a difference in someone's world

Welcome @jonnyboy5 Looks like a successful first day