View Single Post
  #1  
Old March 13th, 2005, 09:34 PM
dave h
external usenet poster
 
Posts: n/a
Default Prompt for DB Field

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.