If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Updating a Form when Table design is changed
I created a table. Then I created a form for data entry based on that table.
Later I made some changes to fields in the table. These changes were not reflected in the form. For example I changed an input mask, a lookup table value, and a field format. Is there a way to update the form without manually doing it? |
#2
|
|||
|
|||
Updating a Form when Table design is changed
No, you have to make the chages to the form in design view.
FYI, you would be advised to avoid using lookup table fields. They are nothing but trouble. -- Dave Hargis, Microsoft Access MVP "GMO" wrote: I created a table. Then I created a form for data entry based on that table. Later I made some changes to fields in the table. These changes were not reflected in the form. For example I changed an input mask, a lookup table value, and a field format. Is there a way to update the form without manually doing it? |
#3
|
|||
|
|||
Updating a Form when Table design is changed
Thank you for your answer. What would the alternative be for a field with a
small defined group of responses that one wants to avoid typing over and over? "Klatuu" wrote: No, you have to make the chages to the form in design view. FYI, you would be advised to avoid using lookup table fields. They are nothing but trouble. -- Dave Hargis, Microsoft Access MVP "GMO" wrote: I created a table. Then I created a form for data entry based on that table. Later I made some changes to fields in the table. These changes were not reflected in the form. For example I changed an input mask, a lookup table value, and a field format. Is there a way to update the form without manually doing it? |
#4
|
|||
|
|||
Updating a Form when Table design is changed
Use a combo box control on your form.
-- Dave Hargis, Microsoft Access MVP "GMO" wrote: Thank you for your answer. What would the alternative be for a field with a small defined group of responses that one wants to avoid typing over and over? "Klatuu" wrote: No, you have to make the chages to the form in design view. FYI, you would be advised to avoid using lookup table fields. They are nothing but trouble. -- Dave Hargis, Microsoft Access MVP "GMO" wrote: I created a table. Then I created a form for data entry based on that table. Later I made some changes to fields in the table. These changes were not reflected in the form. For example I changed an input mask, a lookup table value, and a field format. Is there a way to update the form without manually doing it? |
#5
|
|||
|
|||
Updating a Form when Table design is changed
Thank You Again
"Klatuu" wrote: Use a combo box control on your form. -- Dave Hargis, Microsoft Access MVP "GMO" wrote: Thank you for your answer. What would the alternative be for a field with a small defined group of responses that one wants to avoid typing over and over? "Klatuu" wrote: No, you have to make the chages to the form in design view. FYI, you would be advised to avoid using lookup table fields. They are nothing but trouble. -- Dave Hargis, Microsoft Access MVP "GMO" wrote: I created a table. Then I created a form for data entry based on that table. Later I made some changes to fields in the table. These changes were not reflected in the form. For example I changed an input mask, a lookup table value, and a field format. Is there a way to update the form without manually doing it? |
Thread Tools | |
Display Modes | |
|
|