add new fileds

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
Click to expand...
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]
 
Back
Top