After Deleting a field in a Form, the SQL still has the field

C

cbayardo

Hi, Just wondering why this keeps happening, I am just creating a new
database so I am adding and deleting fields. When I open a Form where I had a
field, it appears as if it is not there, and it really is not there but it is
still in the SQL Source of the Form, so I have to go and take it off from
there. Why is this happening? Did I make myself clear?

Thanks
 
C

Carl Rapson

cbayardo said:
Hi, Just wondering why this keeps happening, I am just creating a new
database so I am adding and deleting fields. When I open a Form where I
had a
field, it appears as if it is not there, and it really is not there but it
is
still in the SQL Source of the Form, so I have to go and take it off from
there. Why is this happening? Did I make myself clear?

Thanks
Click to expand...

There is no connection between a table and a form, so if you add or delete
fields in a table a form bound to the table will not be affected. Any
controls on the form will remain there. You will have to manually modify the
form after modifying the table.

Carl Rapson
 
K

Klatuu

The SQL you are using form the form's record source is independant of the
form. Deleting a control on the form will not remove that control's Control
Source field from the SQL. You have have to do that yourself.
 
Top