Drop-down menus

[jimmonator]

I think this belongs in here... I am a complete novice to Access, and although I have built some complex structures in the past, they have been in Filemaker pro, with no overt references reference to SQL, or VBA. I tend to see the objects as the data, even though I know it not to be strictly true. Anyway:

When I follow instructions for a "drop down box," what I get is a list box showing all the rows of the related table. I have 2 columns showing in there. I want to see only two columns of the top row, and have the other rows "drop down" when I click on it. I should be able be able to drag/scroll down the list to the needed record. I want it to be a menu, really. The Control Source is called Donor_Letters

Upon selecting the needed record, I want to see a separate popup, or subform, like a second browser window, which displays the entire record (row) selected as a small report or memo or form, something where the one very large memo field is easily readable.. I should be able to close this and return to the main form just by clicking a close button.

I hope you can help me out. I just can't see how to make this function like a menu.

Jim

 

[smig]

you should be using what is called ComboBox. It will show you the list of records when you click it.
though you can show in the record list as many columns as you like only one column will be seeing when it's in it's "close" state (before you clikck to show the list)

use the AfterUpdate event to run code after you select a specific record.