Accessing ComboBox values on a form with VBA code behind the form

[Phil H]

I have a Combo Box on a "Menu" form. The source is a three field table that defines facility locations. The Combo Box is Unbound. The "User" is asked to click on the Combo and select one of the facilities. Field 1of the table is the the ID (Autonumber), Field 2 is the name of the facility, and Field 3 is an ID code. I want to access fields 2 and 3 from procedures behind the form. When I use code like X = Me!ComboName, I get the ID field (i.e., a number) of the selected entry. I don't know how to get at the other two fields. I have tried X = Me!ComboName(n) where n in this case is 2 or 3 but that doesn't work. I've also tried X = Me!ComboName("facility") and that doesn't work either. I've read all I have on Combo boxes, but nothing addresses this specific topic (at least not that I've found). Maybe this isn't even possible?
I'll appreciate any help...Phil H

[Gicu]

Most Access collections are zero-based so you need to use Me.ComboName.Column(1) for the facility name and Me.ComboName.Column(2) for the third field Id code. And make sure the columns (number of) property of the combo is set to 3.
Cheers,

[orange]

Further to Vlad's advicet, there are several Combobox articles at techOnTheNet for reference.

[Phil H]

Most Access collections are zero-based so you need to use Me.ComboName.Column(1) for the facility name and Me.ComboName.Column(2) for the third field Id code. And make sure the columns (number of) property of the combo is set to 3.
Cheers,

Vlad:
Thank you...that's exactly what I needed. I have never run across the use of "column" in that context before, although the use of "column" in several of the ComboBox properties maybe should have suggested something to me. Anyway, it will make my ACCESS life a little easier now.
Thanks also to Orange for the references to the ComboBox articles. I wish I'd had those before.
I would mark this as "Solved" except that when I click on Thread Tools, all I get is "Show Printable Version".
Thanks again, Phil H

[Phil H]

OK, after I submitted the above, I went back to the top and clicked on Thread Tools again. This time I got the "solved" option and selected it.

[Gicu]