deleted field still in field list

C

consumer

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.
 
C

consumer

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.
 
A

adsl

consumer said:
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.
Click to expand...
 
A

adsl

consumer said:
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.
Click to expand...
 
Top