Prompt for DB Field

  • Thread starter Thread starter dave h
  • Start date Start date
D

dave h

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.
 
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...
 
suggest you try turning *off* Name AutoCorrect, which can be found from the
menu bar: Tools, Options, General tab. then compact your database.

if that doesn't work, try creating a new database. immediately turn *off*
Name AutoCorrect while the database is "empty". then import all objects from
your project database into the new one. then compact the new database.

note: the Name AutoCorrect option is database-specific, NOT
software-specific. each time you create a new database, you have to turn
that option off manually if you want it off in that database.

hth
 
Back
Top