1->M Table relationship won't expand the dependent data

[Cynthia]

I have a table with a 1->M relationship to another. When I attempt to select
the "+" sign next to the ID of the parent table, I get the "Enter Parameter
Value" box for a field that doesn't exist. It's referring to a field I
changed, but I've gone through all the queries and it's not listed anywhere.
I don't have any forms or reports dependent on this table. The dependent
table uses a lookup field that points to the parent table (Yes, I've looked
at this too). I also have the relationship established within
"Relationships". I'm using Access 2007.

I'm at a loss to where esle to look. Any new revelation on how to fix
this????

Thanks in advance for any enlightment to this issue!

 

[KARL DEWEY]

Try doing a Compact and Repair -- click on TOOLS - Database Utilities -
Compact and Repair Database.

 

[cynteeuh]

I tried that, but I still get the "Enter Parameter Value" prompt.

Anything else to try?

Thanks!

 

[John W. Vinson]

I tried that, but I still get the "Enter Parameter Value" prompt.

Anything else to try?

Go into table design, and view the properties of each field; look in the
Lookup tab and be sure that you don't have that field defined as a linking
field in a lookup (or, better, turn all your lookup fields into Textboxes).