Table / Form Question

[denyoung]

I have a form based upon a table in Access 2007. I change the structure of
the table removing some fields that are displayed on the form. When I return
to form design view to fix the form, the fields are still diplayed in the Add
Existing Fields window although they can't be seen in datasheet view. What's
going on?

Thanks.

 

[Cheese_whiz]

Hi denyoung,

That can happen if you've used a query as the form's recordsource. If
that's the case, you need to delete out the column in your query that use to
represent that field in the table that you deleted from the table.

HTH,
CW

 

[denyoung]

Thanks, but that's not the case.

--
Dennis

Hi denyoung,

That can happen if you've used a query as the form's recordsource. If
that's the case, you need to delete out the column in your query that use to
represent that field in the table that you deleted from the table.

HTH,
CW

 

[Cheese_whiz]

Hi again,

The only other thing I can think of offhand would be to compact the
database. I can't think of anything else beyond those two alternatives,

CW