Outlook Listbox Button

[Billiam]

Could anyone tell me how to produce a listbox arrow button like the ones
used to enter a new contact in Outlook 2007?

In other words, I would like to click on an Arrow button, which brings up a
list of possible choices, and once I choose one of the available choices, it
opens the applicable form?

I am especially wantng to do this for my address and contact number fields
as we track multiple Address types and phone types...

Thank you for any help!
Billiam

 

[Arvin Meyer MVP]

You can do that with any Access listbox. Use the AfterUpdate event of the
listbox to open the form to the specific record, something like this
(untested):

Sub MyList_AfterUpdate()
DoCmd.OpenForm "frmWhatever" ,,, "ID =" & Me.txtID
End Sub

If you want to drill down through a set of data, have a look at:

http://www.accessmvp.com/Arvin/Combo.zip

 

[Billiam]

Thanks, Arvin!
Really appreciate the links, too. Have a great day!

Billiam