Results 1 to 4 of 4
  1. #1
    Acilladon is offline Novice
    Windows XP Access 2003
    Join Date
    Jun 2010
    Posts
    3

    Dropdown Input Box?

    Hi,



    I am fairly new to Access and trying to rejig the database here. Its used for filing documents and were trying to make it clean and simple so that people don't start messing stuff up when they add entries.

    In my form, I would like a button that when clicked has some sort of InputBox pop up then as what query would I like to run. I have several queries each for a specific project so when someone selected Project A, the query would run and show all Project A files with the selected info.

    I guess another thing to ask is having seperate queries for the same function but different Project an issue? (In case it adds to the confusion, the Projects are chosen from a drop down list in the form when you add the record.)

    Any and all help with be welcome

  2. #2
    Acilladon is offline Novice
    Windows XP Access 2003
    Join Date
    Jun 2010
    Posts
    3
    If anyone who feels like helping wants to see the file I am working with, toss your email and I'll send it to you.. its just under 1 MB

  3. #3
    Join Date
    May 2010
    Posts
    339
    In my form, I would like a button that when clicked has some sort of InputBox pop up then as what query would I like to run. I have several queries each for a specific project so when someone selected Project A, the query would run and show all Project A files with the selected info.
    Acilladon,

    You could have a list box showing available queries if they have a prefix of qry. http://www.btabdevelopment.com/ts/samples

  4. #4
    Acilladon is offline Novice
    Windows XP Access 2003
    Join Date
    Jun 2010
    Posts
    3
    Thanks for your reply.. how do I connect that to a button on my form? So when I click the command button that box pops up with my selections

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

Similar Threads

  1. Selecting multiple items from Dropdown
    By Kipster1203 in forum Forms
    Replies: 12
    Last Post: 06-07-2010, 09:20 AM
  2. Dropdown list in a query
    By asherbear in forum Queries
    Replies: 6
    Last Post: 05-31-2010, 06:38 PM
  3. Dropdown - need help please
    By sullyman in forum Access
    Replies: 8
    Last Post: 10-26-2009, 07:48 PM
  4. How to make a Column in Access a DropDown
    By JohnGrove in forum Access
    Replies: 4
    Last Post: 03-10-2009, 07:56 AM
  5. Drop Down, link to another dropdown
    By davelliott in forum Forms
    Replies: 3
    Last Post: 05-23-2006, 08:05 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