Enter Paremeter Value Error?

[snowboarder234]

http://www.box.com/s/0c54a3589dc0a70bbda2 -- database linked here.

In the object tblStudent "Enter Parameter value" error whenever I open the table:



What does that mean and how do I fix it?

Also, when I try to save this 2010 database to a lower version, I get this error listed in the image below. Point being, I don't expect advice on this -- I'm just notifying the forum that I tried to save to a lower version and was not successful, which is odd because I've been able to do so in the past.

[RuralGuy]

Are you perhaps using Lookup Fields? http://access.mvps.org/access/lookupfields.htm

[snowboarder234]

Yes, I have two foreign keys in the tblStudent that link to other tables. Those fields are AdvisorID_FK and CampusID_FK. But I'm a little confused because the error states thus: tblAdvisor.Dept. On that basis I'm assuming it's message is "there's a problem with the department field in the advisor table." However, there is no department field in the advisor table -- the department field is in the student table. I deleted all the relationships and deleted the department field from the student table, but still get the error tblAdvisor.Dept when I open the student table.

Update: I just deleted both foreign keys which were look up fields and now the error does not appear. Looks like I'll have to go back to the drawing board and rethink my initial design. Thank you for pointing me in the right direction.

[RuralGuy]

Glad to hear you got it sorted.