Removed a field from table - now form prompts for the field?

  • Thread starter Thread starter Pamela via AccessMonster.com
  • Start date Start date
P

Pamela via AccessMonster.com

Hi All;

I don't understand why my form is doing this - there must be something about
Access I do not know. I have a table, and have removed a field from the
table. The Control bound to this field has also been removed from the form.
Now when I open the form, I get a prompt for the field. If I click OK or
Cancel, it goes on to open the form.

What could cause this?

Thanks!
 
Is that field in the data source tied to your form? Is it in your sorting?
Is it in your grouping? Is it in your code? It is there somewhere. You
will just have to find it.
 
I searched the code, and the only control that was bound to that field was
removed from the form. If I remove any field from the table, I get prompted
for that field - and these are fields are no longer used. Seems strange that
I get the prompts even for the old fields which are not needed. Guess I'll
keep looking, but there is nothing behind On Load for the form except
Maximize, and the only control that was bound to the field is gone. I was
wondering if there was something else that could be causing it...

Rick said:
Is that field in the data source tied to your form? Is it in your sorting?
Is it in your grouping? Is it in your code? It is there somewhere. You
will just have to find it.
Hi All;
Click to expand...
[quoted text clipped - 9 lines]
Thanks!
Click to expand...
Click to expand...
 
Check the form's record source, for one thing. Also, if you have any events
that refer to that control or that field, you will get an error message.
That could occur if, for instance, a command button is removed, or if there
is a SetFocus event that refers to the control, or something of the sort.
To check the code, start by backing up the database (i.e. copy it to
somewhere safe). Click the form name to select it in the database window
(the database window is what you see first when you open the database,
unless you have explicitly specified otherwise), then click View > Code.
Search just like you would any document, but if you find something and are
unsure about what to do, post another question here. Or just go ahead and
experiment, since you have taken the precaution of backing up.
 
Is the form based on the table, or on a query? If a query, was the field
removed from the query?
 
Nevermind, I found it....it was in the select statement for the record source
for the subform. You were right...had to be there somewhere...

Thanks.
I searched the code, and the only control that was bound to that field was
removed from the form. If I remove any field from the table, I get prompted
for that field - and these are fields are no longer used. Seems strange that
I get the prompts even for the old fields which are not needed. Guess I'll
keep looking, but there is nothing behind On Load for the form except
Maximize, and the only control that was bound to the field is gone. I was
wondering if there was something else that could be causing it...
Is that field in the data source tied to your form? Is it in your sorting?
Is it in your grouping? Is it in your code? It is there somewhere. You
Click to expand...
[quoted text clipped - 5 lines]
Click to expand...
 
I found it in the record source for the subform. I isolated it by trying to
open the subform by itself. The sub form was based on the table I was
modifying. Thanks! :-)
Is the form based on the table, or on a query? If a query, was the field
removed from the query?
Hi All;
Click to expand...
[quoted text clipped - 7 lines]
Thanks!
Click to expand...
Click to expand...
 
Back
Top