Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2008

    Open a table in a From based on a filter

    I want to create a form that will open a table, but not the same table each time. I want the user to be able to choose from a prompt or drop down list which table they want to open in the form. Does anyone have any suggestions to start or can point me in the right direction? Thanks. :roll:

  2. #2
    jya is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Sep 2007
    Do you want to create a dropdown listing all of your available tables? Or, would you already have another table listing the tables you could open?

    To open a table from a dropdown selection, I would add a command button to the form. I would add a line of code in the On_Click event to the effect of table Me!ComboBoxName

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

Similar Threads

  1. Form Based Query/Filter
    By Micon in forum Access
    Replies: 0
    Last Post: 11-07-2008, 09:25 AM
  2. Replies: 3
    Last Post: 10-23-2008, 08:43 AM
  3. Open form based on Subform criteria
    By Suzan in forum Programming
    Replies: 0
    Last Post: 04-25-2006, 02:28 PM
  4. Newbie filter question
    By benplace in forum Access
    Replies: 1
    Last Post: 12-03-2005, 08:31 AM

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