 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / May 2008Chandging Tables and the form not updating??
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 > 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 [quoted text clipped - 3 lines] > Thanks, > Michele 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 > 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 [quoted text clipped - 3 lines] > Thanks, > Michele 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.  SignatureHTH, George > 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 [quoted text clipped - 3 lines] > Thanks, > Michele I am using access 2003. -Michele > 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 [quoted text clipped - 15 lines] > > Thanks, > > Michele 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. SignaturetimH > I am using access 2003. > [quoted text clipped - 19 lines] > > > Thanks, > > > Michele 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! > I am a new user myself but had to do exactly what you are asking a number of [quoted text clipped - 27 lines] > > > > Thanks, > > > > 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. > 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 [quoted text clipped - 36 lines] > > > > > Thanks, > > > > > Michele Got it! Thanks again for everyone's help! Michele > Michele, > [quoted text clipped - 44 lines] > > > > > > Thanks, > > > > > > Michele |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.