Chandging Tables and the form not updating??

  • Thread starter Thread starter Michele
  • Start date Start date
M

Michele

When I change the information in a table, how do I get the form that was
already created to reflect the change? ie. showing new field, changing it to
text or yes/no for example.

Thanks,
Michele
 
First off, forms are built using the table-as-available. Change the table?
You have to modify your form!

Second, you'll want to differentiate between "changing information in a
table" (i.e., values in fields) and "changing information ABOUT a table"
(i.e., the table definition/properties).

Finally, see step one again -- changing a table definition on a field from
Text to Date/Time doesn't tell the form you built (in the past) that
anything's been changed. That's your job.

Good luck!


Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Hmmm, let me backpedal a bit ... newer versions of Access may contain
features that were NOT available before. Which version of Access are you
working with?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
If you add a new field to a table or query that a form is based on, you need
to manually add the new field to the form (View>Field List and drag & drop
the field)

Controls get their default properties from the field properties *as of the
time of creation*. So, if you make a change to the default properties of a
field (Yes/No to True/False or DefaultValue or ControlType...), any existing
controls based on that field will probably NOT reflect those changes (there
are some exceptions, but you're better off not assuming that the changes
will propagate). You can either make the changes manually to each related
control or delete and re-add the field to the form.
 
I am using access 2003.

-Michele

George Nicholson said:
If you add a new field to a table or query that a form is based on, you need
to manually add the new field to the form (View>Field List and drag & drop
the field)

Controls get their default properties from the field properties *as of the
time of creation*. So, if you make a change to the default properties of a
field (Yes/No to True/False or DefaultValue or ControlType...), any existing
controls based on that field will probably NOT reflect those changes (there
are some exceptions, but you're better off not assuming that the changes
will propagate). You can either make the changes manually to each related
control or delete and re-add the field to the form.
Click to expand...
 
Michele!
I am a new user myself but had to do exactly what you are asking a number of
times. Once you have made the changes on your table save, close the table
then Open the Form in desighn view, Click on the field you changed and Cut
both the label and the textBox. Open the Table List for the form and drag
the new(Changed) field in the form and all the properties you changed will
now be shown in the form. save and change to Form view.
 
Tim, Thanks for your response. I undestand what you said for an existing
field already that has been changed. However, I also added a new
"column"/field and it does not show on the field list. How do I get it to
show up on the field list. You would think there would be a "refresh" button.

Thanks again,

Michele
 
Michele,

the new field must show in the field list. Check the name of the form and
assure it is correct. If you have a query behind the form, you need to go to
the query, add the new field in your query and save. Then go to your form
and select field list. You should see it. If you do not at first, school
down the field list...the new field will be at the bottom.
 
Back
Top