Form and databasebase schema

[Vidya]

Hi,

I am desiging a form from my SQLServer2005 database. Since I am in the
initial process of form design, I am having to change my database schema -
add/delete columns. My question is, whenever I do that, will I have to start
designing the form all over again from a dataconenction to see the new fields
added? I dont see that the new fields added are seen in the design layout of
the form under the data source options. Is there a way I can refresh the form
to have the database fields reflected?

Please advice if there is a way to do this.

Thanks in Advance

 

[Hilary Stoupa]

Hello:

In your form, in design mode, go to Tools/Data Connections. Select your main
connection and select Modify. The new columns that you have added to your
table will show in the data source structure, but they will not be selected.
Select the addtional columns you wish to have connected to your form, then
select Next and Finish.