Update table binding to a form

tfurnivall

Registered User.
Local time
Today, 03:40
Joined
Apr 19, 2012
Messages
81
Hello - I have a set of tables and a form that I'm using to design an application to track my CDs. Part of the "Learn How to Use Access 2010" process.

I'm designing it iteratively, and I now need to update the underlying table design for one of the tables in the form. I can no longer 'get to' the updated table definition, so I can't reference the field I just added.

It seems a little futile to force the entire form to be scrapped and redesigned just because of a simple change to one of the underlying tables. My question is, "Is this possible - to adjust the binding between a form and one of the underlying tables? Or do I have to become a design purist and complete everything before doing anything else? (Which kind of defeats the idea of iterative design....)

Thanks in advance,

Tony (NYC and still recovering from Sandy!)
 
When you update the schema of a table, forms associated with the table will understand the change right away.

If you add a field, there is no magic that automatically adds the new field to the form as a control, however.

From the Design tab of the form in design mode, you may click the Add Fields button and drag the new field you have added to the table where you would like the field on the form.
 

Users who are viewing this thread

Back
Top Bottom