Table behaving like parameter query

[Pete Morris]

ooo err,

I have had a database for quite a while, which has been running ok.......
I have recently been tarting about with it, adding some code to forms in order that updates can be made to lookup tables etc.

Everything is working fine apart from....

If I double click on one of the tables it asks for a parameter...... this isn't a problem as I can just click yes and get all the details and view the tables through queries anyway,
but does anyone know why this is happening and what I can do to stop it??????????

Thanks, Pete.

 

[charityg]

Check the lookp setting for the fields on the tables and make sure you aren't referencing a missing table/query/field.

 

[Pat Hartman]

Also check the datasheet properties to be certain that you are not sorting on a field that has been removed or renamed.