No such field in the Field list

[natalie]

Hello,
I supposed to change an existing Access database used for Inventory.
I added a field and a check box - when checking the check box, the amount supposed to appear in the text box. It says "No such field in the Field list" and "Invalid control property: Source control".


This form already has similar fields - i compared , it looks the same, but still doesnt work. Added the code side as well.

Will appreciate your help

Thanks

[RuralGuy]

I will assume you are using a query as the RecordSource of the form. You need to refresh the query. You do this by deleting the RecordSource and then setting it again.

[natalie]

Thanks for your reply, Ruralguy
How can I delete and set again the resordset? i found it in the source code - just to delete and paste in the same place? Dont think that what you mean.

[RuralGuy]

You have it. Just delete the RecordSource property from the Data tab of the property sheet for the form. I would probably save the form once and then just pick the Query again. Eash form develops a strategy to run a query once one is selected and saved. This strategy is not updated when the original table is modified, hence the need to force the form to create the strategy again.

[natalie]

When setting the record source, noticed there is another table that needs a change - tried to add a field, but it said that can't save changes in linked table.

[RuralGuy]

All that you are attempting should be achieved in the Query Builder, not in a form.

[natalie]

i need to add a column to the table where the query is pulling data from

[RuralGuy]

You should do that directly inh the table.

[natalie]

im trying to do it directly in the table, but get a message "can't save changes in linked table"

[RuralGuy]

Which is true! You need to be in the BackEnd mdb and not the FrontEnd.

[natalie]

Right, I'll try to add columns in SQL Server

Thanks

[RuralGuy]

Let us know how you make out.

[natalie]

i'm trying to connect to test server, created ODBC connection, but can't find where can I change datasource in Access, because it gives me live server by default.

Thanks

[RuralGuy]

I'm afraid I can not be of much help with SQL Server, sorry.

[natalie]

Its not SQL server - its datasource in Access. Is it possible to change?

Thanks