deleted field still in field list

[Guest]

I created a form/subform based on fields A, B, C from table ONE and D from
table TWO. Some time later, I decided that didn't need field C anymore, so I
deleted it from table ONE (from the form design view and from the actual
table).

However, now everytime I open the form it asks me to enter a value for field
C.

Didn't know why until I opened the form and viewed the field list....and C
is still listed there....even thought the field doesn't exist anymore.

As well, if I widen the field list window there is a SELECT statement in the
window title bar that says: SELECT ONE.A, ONE.B, ONE.C, TWO.D from TWO INNER
JOIN ONE on ONE.x=TWO.x;

How can I get rid of C from the field list and from this "embedded query?

thanks in advance.

 

[Arvin Meyer]

Edit the query to eliminate the field.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Joseph Meehan]

I created a form/subform based on fields A, B, C from table ONE and D
from table TWO. Some time later, I decided that didn't need field C
anymore, so I deleted it from table ONE (from the form design view
and from the actual table).

However, now everytime I open the form it asks me to enter a value
for field C.

Didn't know why until I opened the form and viewed the field
list....and C is still listed there....even thought the field doesn't
exist anymore.

As well, if I widen the field list window there is a SELECT statement
in the window title bar that says: SELECT ONE.A, ONE.B, ONE.C, TWO.D
from TWO INNER JOIN ONE on ONE.x=TWO.x;

How can I get rid of C from the field list and from this "embedded
query?

thanks in advance.

Delete the reference to Table C in the form.

 

[Guest]

Thanks Joseph and Arvind.

I saw the query under the Properties and was able to remove the reference.
The problem was at first that I couldn't find the Query...because it wasn't
listed with the normal Access queries.

 

[adsl]

Thanks Joseph and Arvind.

I saw the query under the Properties and was able to remove the reference.
The problem was at first that I couldn't find the Query...because it
wasn't
listed with the normal Access queries.

 

[adsl]

Thanks Joseph and Arvind.

I saw the query under the Properties and was able to remove the reference.
The problem was at first that I couldn't find the Query...because it
wasn't
listed with the normal Access queries.