If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Parameter queries that allow users to choose items from a list
Dear Access 2007 VBA Gurus,
I have a "Worship Song" database. The tables a tblWorshipSongs tblAuthorFirstNames tblAuthorLastNames tblCopyrightHolders tblKeys tblTempos tblSongThemes tblSongTypes I would like to create parameter queries that allow users to choose their parameter from a list, preferably the entries from one of the tables. For example, suppose I wanted to query all the songs by a particular author's last name. I don't just want users to type in a last name, in which case they might misspell it and return no records, or type in an entry that is not already in the table (and again get no records returned). I would like to limit the user's choices to the last names already in the last names table and allow the user to choose from a drop-down list of those last names to run the query. I am a VBA beginner, and I have made a few attempts at this, but so far, no luck--help! -- Joe Venable Virginia Beach, VA |
Thread Tools | |
Display Modes | |
|
|