Dave

Sometimes when a field has been renamed in both table and form, an
underlying query is overlooked. Is there a chance your form is based on a
query, based on the table? If so, or if there is a combo box in the form
that is based on the table, check there...

--
Good luck

Jeff Boyce
Access MVP

"dave h" wrote in message
...
Hi,

My problems goes like this - Table1 has field1. Form1 has VBA/SQL/DAO
code
that references field1.

Field1 had its name changed to field2. The reference in Form1 was changed
to field2.

Now, Access prompts for field1 when the form is trying to come up - there
is
now zero reference to field1.

If I put a field back into table1 with the name field1, the prompt goes
away
(of course, this is not acceptable)

This is a complicated DB and forms. I'd really not like to scrap the form
an start over to get rid of this prompt.

All suggestions will be appreciated - Thanks, Dave H.