Field List Not Updating With New Fields

[Rlmccants]

Any help would be much appreciated as I have been pulling out my hair trying to figure this out.

I have a subform that is bound to a query. I added six fields to the underlying table, then added those fields to the query, but the Field List in the form will not show the additional fields.

I have tried "refresh", I have tried Compacting, and I have tried closing the database. I've also attempted to add the field using the ...expression builder, but it shows #Name? in the form's input.

What am I missing?

Thanks

 

[boblarson]

What does the form's RECORD SOURCE property say in it right now? Is it the name of your query or does it start with the word SELECT?

 

[Rlmccants]

It starts with SELECT and then it has the field names...excluding the names that I've added...

 

[Rlmccants]

By changing it to the Query name, it shows all of the fields! Thanks Bob Larson!

 

[boblarson]

You are welcome.

 

[Rlmccants]

I know there is value in trying to figure things out by yourself before asking for help, but gosh...I've been struggling with this for the last two days...lol

 

[boblarson]

Just remember, it is OKAY to have the SELECT ... in the record source but if anything changes, you need to manually make the change to select or delete any added/deleted fields there.