Results 1 to 2 of 2
  1. #1
    Paul H's Avatar
    Paul H is offline Expert
    Windows XP Access 2010 32bit
    Join Date
    Sep 2011
    Location
    Richmond, VA
    Posts
    591

    Strange Prompt When Opening Table

    I have a table that is prompting for a parameter when I open it. The table name is Resubmits and the prompt is Resubmits.Resub_ID, like so. Click image for larger version. 
<br /><script async src=
    Name: resub_ID.JPG  Views: 6  Size: 14.8 KB  ID: 25322" class="thumbnail" style="float:CONFIG" />


    There is no such field in the table and the table is has no links set up in the Relationship section. I can just blow threw this pop up and the table opens, but I'm disturbed by this. I would like to make this disappear, but have no idea where to be. Compact and repair have no effect.

    Any suggestions?

  2. #2
    Paul H's Avatar
    Paul H is offline Expert
    Windows XP Access 2010 32bit
    Join Date
    Sep 2011
    Location
    Richmond, VA
    Posts
    591
    Answered my own question almost instantly. I went into design mode and noted that Resub_ID was referenced in the Filter and the Order By properties. I removed them and the prompt went away. I rarely, very rarely look at this table, but this field must have existed some time in the past. Who knows when. Doesn't matter now. Mystery solved.

    That is all.

    Paul

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 08-03-2012, 08:15 AM
  2. Replies: 7
    Last Post: 05-09-2012, 06:06 AM
  3. Prompt for a table.
    By kmcg1888 in forum Queries
    Replies: 1
    Last Post: 02-10-2012, 08:10 AM
  4. continuous prompt for credentials when opening mysql table
    By ajetrumpet in forum Import/Export Data
    Replies: 0
    Last Post: 10-30-2010, 11:52 PM
  5. Replies: 6
    Last Post: 03-17-2010, 10:09 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums