automatical updates on forms

[nawara]

hi
i have created both a table and a form .. i recently altered my table.. however these alterations havent shown in my form?
is there a way i could automitically update my form without having to delete it and recreate it?
Regards Noor .

 

[burrcm]

No, not automatic but you don't have to delete the form, just open it in design, select View - field list and drag the new fields to the form.

Chris B

 

[nawara]

No, not automatic but you don't have to delete the form, just open it in design, select View - field list and drag the new fields to the form.

Chris B

hey thnks for getin bak to me ..

but the thing i changed in my table was the order of one of my feilds. for example i changed my feild Date in assending order..
i just assumed that it would automatically show in my forms
apparently not !
Noor

 

[burrcm]

If the form is based directly on the table, it should, if not, delete the field and add it again. If the form is based on a query, set the sort order in the query.

Chris B

 

[Pat Hartman]

If you think about it in the greater scheme of things, it does not really make sense for table changes or query changes to be propagated to forms or reports. Access has no way to know that you want every field of a table to appear on a particular form. As to sort sequence, YOU again have control over that by using a query with an order by clause.