Pull multiple combobox values into separate vb variables

[Phred]

VB skill livel moderate.

I have a combobox that pulls three values:

ItemName, Cost, LowestPriceVendor.

ItemName is bound column.

I know how to pull ItemName into VB as a variable in the after update event.

What I don't know is how to pull the other two values into VB as seperate variables so I can reuse them

I can't seem to figure out the right syntax.

Here is my combobox select statement. It works fine.

SELECT [Qry_SelectAlternateItem].[ItemName], [Qry_SelectAlternateItem].[PriceperUnit], [Qry_SelectAlternateItem].[LowestPriceVendor] FROM Qry_SelectAlternateItem ORDER BY [ItemName];

In VB I can do the following, pop it in a variable, and get the ItemName.

Forms!Sub_Frm_Modal_EditScheduledMeal!CmbSelectAlt Item.SetFocus
stAltItm = Forms!Sub_Frm_Modal_EditScheduledMeal!CmbSelectAlt Item.Text

Thanks,

Phred

[pbaldy]

This should help (you want the Column property):

http://www.baldyweb.com/Autofill.htm

By the way, you won't need the SetFocus line if you drop .Text from the next line. .Value is the default, and it's what you want anyway.

[Phred]

This is a beautiful thing. It is solved. And thanks for the help on the other item. I just put it into action.

Many thanks, Phred

stCatID = Forms!Frm_countsparent!CmbPickCat.Column(0)
stPickCat = Forms!Frm_countsparent!CmbPickCat.Column(1)
stSiteId = Forms!Frm_countsparent!CmbPickSite.Column(0)
stSiteName = Forms!Frm_countsparent!CmbPickSite.Column(1)
stYear = Forms!Frm_countsparent!PickYear.Column(0)
stMonth = Forms!Frm_countsparent!PickMonth.Column(0)

[pbaldy]

Happy to help!