Seeing added table fields in a form

M

Matt

I am trying to add a new field to a table, and then get it added to the
fieldlist in the form that is connected to this table. I succesfully create
the field in the table, even add values, but when I go to the form, it is not
there. It is not present for the field list, nor the datasource list
available in the properties of the textbox that is supposed to use this new
field.
Do I have to refresh the form or field list some how?
Any and all help would be much appreciated.
 
J

Jeff Conrad

in message:
I am trying to add a new field to a table, and then get it added to the
fieldlist in the form that is connected to this table. I successfully create
the field in the table, even add values, but when I go to the form, it is not
there. It is not present for the field list, nor the datasource list
available in the properties of the textbox that is supposed to use this new
field.
Do I have to refresh the form or field list some how?
Any and all help would be much appreciated.
Click to expand...

Hi Matt,

If your form is based on a saved query you will need to add the
new field to the query itself. Then it will become available in the
form. If your form is based on a SQL statement you will need
to add it there. If you go to the form's properties' list look on
the Data or All tabs for an option called "Record Source."
Click on that line and a small button will appear (...) Click
there to bring up a query diagram. Add in the new field here.
Save the form and then the field will become available.
 
Top