Outlook Listbox Button

  • Thread starter Thread starter Billiam
  • Start date Start date
B

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
 
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
 
Back
Top