none
Enter Parameter Value when opening table... RRS feed

  • Question

  • When I open one of the tables in my app, I'm being prompted to enter a Parameter Value for one of the fields in the table.  I have opened all of my Tables, Queries, Forms and Reports in search of what might be causing this.  I've also looked in Relationships to see if there was an issue, but for the life of me - can't find it.

    Any suggestions on how to narrow this down?

    Thank you!


    Thanks for your help!!

    Monday, April 3, 2017 7:08 PM

Answers

  • Prompts can happen with forms, reports and queries if a field is being referenced and is missing, but I've never seen that happen with a table. 

    If you are prompted when opening a table my only guess is that you have a data macro that is looking for a field that isn't there, or maybe a field has a look-up. Open the table in design view, select a field and take a look at the Lookup tab below. If the type is not a Text Box, it has a lookup field in a related table.




    Bill Mosca
    www.thatlldoit.com
    http://tech.groups.yahoo.com/group/MS_Access_Professionals

    • Marked as answer by plynton Monday, April 3, 2017 7:38 PM
    Monday, April 3, 2017 7:30 PM