add new fileds

[Guest]

I added a new field in my backend database (SQL server)
i deleted and relink the table.
The link table has new field.
I tried to add this new field on the form, but I can not access this form
through my query.
For example, my form data source is

SELECT MyField1, MyField2 From MyTable.

I can not change to

SELECT MyField1, MyField2, MyNewField From MyTable.


Do I need do anything to access the new field I just added?

Any information is great appreciated.

 

[John Vinson]

I added a new field in my backend database (SQL server)
i deleted and relink the table.
The link table has new field.
I tried to add this new field on the form, but I can not access this form
through my query.
For example, my form data source is

SELECT MyField1, MyField2 From MyTable.

I can not change to

SELECT MyField1, MyField2, MyNewField From MyTable.


Do I need do anything to access the new field I just added?

Any information is great appreciated.

Open the form in design view; view its Properties. Select the
Recordsource property (first on the Data tab). Click the ... icon by
it; a query design window will open.

Add the new field to this query and close it, accepting Access' offer
to save.

John W. Vinson[MVP]