Hi, I read the thread on this similar topic. The question I have for Mr. Purdy, is what is 'Backend'?
I tried to add a new field into my table in Access (2002). I see the updated field in the Relationship view. But, I don't see it in the Form (Field-List). I could run a query with the new field added.
But I want to add the new field onto the Form I have already created and I cannot seem to find the answer to that.
Is there a way to update a form to reflect changes made in a Table?
Please advise,
Winnie
golfinray wrote:
Are you talking about the field list of a form or report?
05-Jan-10
Are you talking about the field list of a form or report? If so, you add th
field to the tableor query that runs the form or report then re-open the for
and the new field will be in the list. If you are talking about adding field
to a table, you could go to design view and add it unless it is a linke
table and then you go to the backend and add it there, then refresh the table
-
Milton Purd
ACCES
State of Arkansa
:
Previous Posts In This Thread:
Unable to Refresh Fields in Field list
H
I am trying to update the Field list on my Database. The Refresh Button fo
this purpose should be on the field list toolbar but I cannot see it anywhere
either I am being exceedingly dense or I am not looking in the right place
This is a older version of Office (Office Proffesional 2003). It was alread
installed on the PC when I started
Don W
There is no button for that.
There is no button for that. If the recordsource of the form or report tha
you are trying to refresh is a query, you need to add the field to tha
query. The only way that would happen is by either manually adding th
field, or if your query outputs all fields
Select * From tblWhatever
-
Arvin Meyer, MCP, MV
http://www.datastrat.co
http://www.mvps.org/acces
http://www.accessmvp.com
An Access database does not have a "field list".
An Access database does not have a "field list". Access has tables, whic
have fields. Access has queries that have fields
More info, please..
-
Regard
Jeff Boyc
Microsoft Access MV
Disclaimer: This author may have received products and services mentioned i
this post. Mention and/or description of a product or service herein doe
not constitute endorsement thereof
Any code or pseudocode included in this post is offered "as is", with n
guarantee as to suitability
You can thank the FTC of the USA for making this disclaime
possible/necessary.
Are you talking about the field list of a form or report?
Are you talking about the field list of a form or report? If so, you add th
field to the tableor query that runs the form or report then re-open the for
and the new field will be in the list. If you are talking about adding field
to a table, you could go to design view and add it unless it is a linke
table and then you go to the backend and add it there, then refresh the table
-
Milton Purd
ACCES
State of Arkansa
:
A database does not have a field list. Tables and queries have fields/columns.
A database does not have a field list. Tables and queries have fields/columns
A form or report design view allows you to view a "Field List" which are al
of the fields/columns in the Record Source of your form or report
-
Duane Hooko
Microsoft Access MV
:
Hi Don,Are you talking about the field list that one sees in form or report
Hi Don
Are you talking about the field list that one sees in form or report desig
view via View | Field List? There is no refresh button for this list. I
your field list is empty, then you need to assign a recordset to the form o
report
Tom Wickerat
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________
:
Submitted via EggHeadCafe - Software Developer Portal of Choice
EggHeadCafe Chat Chaos in Silverlight Released Today
http://www.eggheadcafe.com/tutorial...6-54f31bdede5d/eggheadcafe-chat-chaos-in.aspx