Help!!! Renaming and deleting fields

[Mike Farmer]

When I rename a field the new name doesn't show up in the field list and
I can't seem to "bind" a control to the new field. Also the old name is
still there and I keep getting that "Enter parameter value" message when
I use the form. Also getting that message when I delete a field. Appears
to be no way to edit a "field list"

Here's what I did. I have a table named: Patient Information. I changed
a field name from: "date closed" to: "IME Completed (Y/N)" No input
mask, default value is "N"

I then went into "form design" to change the control properties. The
control source still list: "date closed" in the "drop down" but not the
new field "IME Completed (Y/N)and when I enter "IME Completed (Y/N)" I
get an "unbound" error.

Don't understand what I'm doing wrong. Why should changing or deleting
field names cause such problems. Seems there should be a simple way to
resolve this.

Any help would be much appreciated as I need to rename many fields,
delete some and add some. Last time, I simply started from scratch and
"redid" the whole thing. Don't want to do that now as, I've added too
much to the database.

 

[Graham R Seach]

Mike,

When you renamed the table field, you neglected to make the appropriate
change to the qury on which the form is based. Fix the query and the problem
will go away.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

 

[Mike Farmer]

I'm sorry but I don't follow. How do I find the query?? When I click on
the elipses for the control properties the "expression builder appears.

 

[Graham R Seach]

Mike,

Check the form's RecordSource property. The name listed in there is most
likely the name of a query, rather than a table. Find the query, open it,
and rename the field as you did in the table.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

 

[Mike Farmer]

Yep!!!! Thanks !!!!!

Mike,

Check the form's RecordSource property. The name listed in there is most
likely the name of a query, rather than a table. Find the query, open it,
and rename the field as you did in the table.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia